Generated using SQL Data Dictionary demo version.


Table Production.Document (13 rows)


Product maintenance documents.


  Column Data Type Identity Nullable Default
PK,  UK DocumentNode hierarchyid
Primary key for Document records.
UK DocumentLevel smallint X
Depth in the document hierarchy.
Title nvarchar(50)
Title of the document.
FK Owner int
Employee who controls the document. Foreign key to Employee.BusinessEntityID
FolderFlag bit 0
0 = This is a folder, 1 = This is a document.
FileName nvarchar(400)
File name of the document
FileExtension nvarchar(8)
File extension indicating the document type. For example, .doc or .txt.
Revision nchar(5)
Revision number of the document.
ChangeNumber int 0
Engineering change approval number.
Status tinyint
1 = Pending approval, 2 = Approved, 3 = Obsolete
DocumentSummary nvarchar(max) X
Document abstract.
Document varbinary(max) X
Complete document.
UK rowguid uniqueidentifier newid()
ROWGUIDCOL number uniquely identifying the record. Required for FileStream.
ModifiedDate datetime getdate()
Date and time the record was last updated.

Indexes:


References:


Referenced by: