Production.Document (table)

wikibot

Table

Production.Document

Column	Data Type	Nullable	Default	PK	Index
DocumentID	int	not null		PK_Document_DocumentID
Title	nvarchar(50)	not null
FileName	nvarchar(400)	not null			AK_Document_FileName_Revision
FileExtension	nvarchar(8)	not null
Revision	nchar(5)	not null			AK_Document_FileName_Revision
ChangeNumber	int	not null	((0))
Status	tinyint	not null
DocumentSummary	nvarchar(max)	null
Document	varbinary(max)	null
ModifiedDate	datetime	not null	(getdate())

Detail Table	Column	Referencing Column
Production.ProductDocument	DocumentID	DocumentID

automatically generated

Table	Production.Document
Description	Product maintenance documents.

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.

Detail Table	Column	Referencing Column
Production.ProductDocument	DocumentID	DocumentID