Production.Document (table)
wikibot
| Table | Production.Document |
| Description | Product maintenance documents. |
| Column | Data Type | Nullable | Default | Description / PK / Index |
| DocumentID | int | not null | Primary key for Document records. PK_Document_DocumentID | |
| Title | nvarchar(50) | not null | Title of the document. | |
| FileName | nvarchar(400) | not null | Directory path and file name of the document AK_Document_FileName_Revision | |
| FileExtension | nvarchar(8) | not null | File extension indicating the document type. For example, .doc or .txt. | |
| Revision | nchar(5) | not null | Revision number of the document. AK_Document_FileName_Revision | |
| ChangeNumber | int | not null | ((0)) | Engineering change approval number. |
| Status | tinyint | not null | 1 = Pending approval, 2 = Approved, 3 = Obsolete | |
| DocumentSummary | nvarchar(max) | null | Document abstract. | |
| Document | varbinary(max) | null | Complete document. | |
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated. |
| Detail Table | Column | Referencing Column |
| Production.ProductDocument | DocumentID | DocumentID |
automatically generated
| Table | Production.Document |
| Description | Product maintenance documents. |
| Column | Data Type | Nullable | Default | Description / PK / Index |
| DocumentID | int | not null | Primary key for Document records. PK_Document_DocumentID | |
| Title | nvarchar(50) | not null | Title of the document. | |
| FileName | nvarchar(400) | not null | Directory path and file name of the document AK_Document_FileName_Revision | |
| FileExtension | nvarchar(8) | not null | File extension indicating the document type. For example, .doc or .txt. | |
| Revision | nchar(5) | not null | Revision number of the document. AK_Document_FileName_Revision | |
| ChangeNumber | int | not null | (0) | Engineering change approval number. |
| Status | tinyint | not null | 1 = Pending approval, 2 = Approved, 3 = Obsolete | |
| DocumentSummary | nvarchar(max) | null | Document abstract. | |
| Document | varbinary(max) | null | Complete document. | |
| ModifiedDate | datetime | not null | (GETDATE()) | Date and time the record was last updated. |
| Detail Table | Column | Referencing Column |
| Production.ProductDocument | DocumentID | DocumentID |
| Dependency Type | Object Type | Referenced Object |
| Schema | Schema | Production |
