Document Table (AdventureWorks)

Contains product maintenance documents stored as Microsoft Office Word files.

Document Table Definition

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.