| 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.
|