Latest revision |
Your text |
Line 2: |
Line 2: |
| | | |
| {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |
− | |- valign="top" | + | |- |
| | '''Table | | | '''Table |
| | Production.Document | | | Production.Document |
− | |- valign="top" | + | |- |
− | | '''Description
| |
− | | Product maintenance documents.
| |
| |} | | |} |
| | | |
− | === Columns ===
| + | |
| {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |
| |- style="background:silver" | | |- style="background:silver" |
Line 17: |
Line 15: |
| | '''Nullable | | | '''Nullable |
| | '''Default | | | '''Default |
− | | '''Description | + | | '''PK |
− | | + | | '''Index |
− | |- valign="top" | + | |
| + | |- |
| | DocumentID | | | DocumentID |
| | int | | | int |
| | not null | | | not null |
| | | | | |
− | | Primary key for Document records. | + | | PK_Document_DocumentID |
− | |- valign="top" | + | | |
| + | |- |
| | Title | | | Title |
| | nvarchar(50) | | | nvarchar(50) |
| | not null | | | not null |
| | | | | |
− | | Title of the document. | + | | |
− | |- valign="top" | + | | |
| + | |- |
| | FileName | | | FileName |
| | nvarchar(400) | | | nvarchar(400) |
| | not null | | | not null |
| | | | | |
− | | Directory path and file name of the document | + | | |
− | |- valign="top" | + | | AK_Document_FileName_Revision |
| + | |- |
| | FileExtension | | | FileExtension |
| | nvarchar(8) | | | nvarchar(8) |
| | not null | | | not null |
| | | | | |
− | | File extension indicating the document type. For example, .doc or .txt. | + | | |
− | |- valign="top" | + | | |
| + | |- |
| | Revision | | | Revision |
| | nchar(5) | | | nchar(5) |
| | not null | | | not null |
| | | | | |
− | | Revision number of the document. | + | | |
− | |- valign="top" | + | | AK_Document_FileName_Revision |
| + | |- |
| | ChangeNumber | | | ChangeNumber |
| | int | | | int |
| | not null | | | not null |
| | ((0)) | | | ((0)) |
− | | Engineering change approval number. | + | | |
− | |- valign="top" | + | | |
| + | |- |
| | Status | | | Status |
| | tinyint | | | tinyint |
| | not null | | | not null |
| | | | | |
− | | 1 = Pending approval, 2 = Approved, 3 = Obsolete | + | | |
− | |- valign="top" | + | | |
| + | |- |
| | DocumentSummary | | | DocumentSummary |
| | nvarchar(max) | | | nvarchar(max) |
| | null | | | null |
| | | | | |
− | | Document abstract. | + | | |
− | |- valign="top" | + | | |
| + | |- |
| | Document | | | Document |
| | varbinary(max) | | | varbinary(max) |
| | null | | | null |
| | | | | |
− | | Complete document. | + | | |
− | |- valign="top" | + | | |
| + | |- |
| | ModifiedDate | | | ModifiedDate |
| | datetime | | | datetime |
| | not null | | | not null |
| | (getdate()) | | | (getdate()) |
− | | Date and time the record was last updated.
| |
− | |}
| |
− |
| |
− | === Primary Key ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Primary Key
| |
− | | '''Columns
| |
− | |- valign="top"
| |
− | | PK_Document_DocumentID
| |
− | | DocumentID
| |
− | |}
| |
− |
| |
− | === Indexes ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Index
| |
− | | '''Type
| |
− | | '''Columns
| |
− |
| |
− | |- valign="top"
| |
− | | AK_Document_FileName_Revision
| |
− | | Unique
| |
− | | FileName, Revision
| |
− | |}
| |
− |
| |
− | === Check Constraints ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Check Constraint
| |
− | | '''Expression
| |
− | | '''Description
| |
− |
| |
− | |- valign="top"
| |
− | | CK_Document_Status
| |
− | | ([Status]>=(1) AND [Status]<=(3))
| |
− | | Check constraint [Status] BETWEEN (1) AND (3)
| |
− | |}
| |
− |
| |
− | === Detail Tables ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Detail Table
| |
− | | '''Column
| |
− | | '''Referencing Column
| |
− |
| |
− | |- valign="top"
| |
− | | [[Production.ProductDocument_(table)|Production.ProductDocument]]
| |
− | | DocumentID
| |
− | | DocumentID
| |
− | |}
| |
− |
| |
− | === References ===
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Dependency Type
| |
− | | '''Object Type
| |
− | | '''Referenced Object
| |
− |
| |
− | |- valign="top"
| |
− | | Schema
| |
− | | Schema
| |
− | | [[Production_(schema)|Production]]
| |
− |
| |
− | |}
| |
− |
| |
− |
| |
− | == automatically generated ==
| |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |-
| |
− | | '''Table
| |
− | | Production.Document
| |
− | |- valign="top"
| |
− | | '''Description
| |
− | | Product maintenance documents.
| |
− | |-
| |
− | |}
| |
− |
| |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Column
| |
− | | '''Data Type
| |
− | | '''Nullable
| |
− | | '''Default
| |
− | | '''Description / PK / Index
| |
− |
| |
− | |- valign="top"
| |
− | | DocumentID
| |
− | | int
| |
− | | not null
| |
− | |
| |
− | | Primary key for Document records.<br />PK_Document_DocumentID
| |
− | |- valign="top"
| |
− | | Title
| |
− | | nvarchar(50)
| |
− | | not null
| |
− | |
| |
− | | Title of the document.<br />
| |
− | |- valign="top"
| |
− | | FileName
| |
− | | nvarchar(400)
| |
− | | not null
| |
| | | | | |
− | | Directory path and file name of the document<br />AK_Document_FileName_Revision
| |
− | |- valign="top"
| |
− | | FileExtension
| |
− | | nvarchar(8)
| |
− | | not null
| |
| | | | | |
− | | File extension indicating the document type. For example, .doc or .txt.<br />
| |
− | |- valign="top"
| |
− | | Revision
| |
− | | nchar(5)
| |
− | | not null
| |
− | |
| |
− | | Revision number of the document. <br />AK_Document_FileName_Revision
| |
− | |- valign="top"
| |
− | | ChangeNumber
| |
− | | int
| |
− | | not null
| |
− | | (0)
| |
− | | Engineering change approval number.<br />
| |
− | |- valign="top"
| |
− | | Status
| |
− | | tinyint
| |
− | | not null
| |
− | |
| |
− | | 1 = Pending approval, 2 = Approved, 3 = Obsolete<br />
| |
− | |- valign="top"
| |
− | | DocumentSummary
| |
− | | nvarchar(max)
| |
− | | null
| |
− | |
| |
− | | Document abstract.<br />
| |
− | |- valign="top"
| |
− | | Document
| |
− | | varbinary(max)
| |
− | | null
| |
− | |
| |
− | | Complete document.<br />
| |
− | |- valign="top"
| |
− | | ModifiedDate
| |
− | | datetime
| |
− | | not null
| |
− | | (GETDATE())
| |
− | | Date and time the record was last updated.<br />
| |
| |} | | |} |
| | | |
Line 240: |
Line 102: |
| | DocumentID | | | DocumentID |
| | DocumentID | | | DocumentID |
− | |}
| |
− |
| |
− |
| |
− | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
| |
− | |- style="background:silver"
| |
− | | '''Dependency Type
| |
− | | '''Object Type
| |
− | | '''Referenced Object
| |
− |
| |
− | |-
| |
− | | Schema
| |
− | | Schema
| |
− | | [[Production_(schema)|Production]]
| |
− |
| |
| |} | | |} |