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.