Document Table (AdventureWorks)
Contains product maintenance documents stored as Microsoft Office Word files.
The Document table is contained in the Production schema.
Column | Data type | Nullability | Description |
---|---|---|---|
DocumentID |
int |
Not null |
Primary key for Document rows. |
Title |
nvarchar(50) |
Not null |
Title of the document. |
FileName |
nvarchar(400) |
Not null |
Directory path and file name of the document. |
FileExtension |
nvarchar(8) |
Not null |
File extension indicating the document type. For example, .doc or .txt. |
Revision |
nvarchar(5) |
Not null |
Revision number of the document. |
ChangeNumber |
int |
Not null |
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 file. |
ModifiedDate |
datetime |
Not null |
Date and time the row was last updated. |
Product Table (AdventureWorks)
ProductDocument Table (AdventureWorks)