Production.Document (table)

wikibot

Table	Production.Document
Description	Product maintenance documents.

Columns

Column	Data Type	Nullable	Default	Description
DocumentID	int	not null		Primary key for Document records.
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	nchar(5)	not null		Revision number of the document.
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.

Primary Key

Primary Key	Columns
PK_Document_DocumentID	DocumentID

Indexes

Index	Type	Columns
AK_Document_FileName_Revision	Unique	FileName, Revision

Check Constraints

Check Constraint	Expression	Description
CK_Document_Status	([Status]>=(1) AND [Status]<=(3))	Check constraint [Status] BETWEEN (1) AND (3)

Detail Tables

Detail Table	Column	Referencing Column
Production.ProductDocument	DocumentID	DocumentID

References

Dependency Type	Object Type	Referenced Object
Schema	Schema	Production

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

Dependency Type	Object Type	Referenced Object
Schema	Schema	Production