Production.Document - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Production
Name	Document
Module	Products

Product maintenance documents.

Columns

		Name	Data type	Attributes	Description
	1	DocumentNode	hierarchyid		Primary key for Document records.
Primary key for Document records.
	2	DocumentLevel	smallint	Computed: [DocumentNode].[GetLevel]()	Depth in the document hierarchy.
Depth in the document hierarchy. Computed: [DocumentNode].[GetLevel]()
	3	Title	nvarchar(50)		Title of the document.
Title of the document.
	4	Owner	int		Employee who controls the document. Foreign key to Employee.BusinessEntityID
Employee who controls the document. Foreign key to Employee.BusinessEntityID
	5	FolderFlag	bit	Default: 0	0 = This is a folder, 1 = This is a document.
0 = This is a folder, 1 = This is a document. Default: 0
	6	FileName	nvarchar(400)		File name of the document
File name of the document
	7	FileExtension	nvarchar(8)		File extension indicating the document type. For example, .doc or .txt.
File extension indicating the document type. For example, .doc or .txt.
	8	Revision	nchar(5)		Revision number of the document.
Revision number of the document.
	9	ChangeNumber	int	Default: 0	Engineering change approval number.
Engineering change approval number. Default: 0
	10	Status	tinyint		1 = Pending approval, 2 = Approved, 3 = Obsolete
1 = Pending approval, 2 = Approved, 3 = Obsolete
	11	DocumentSummary	nvarchar(MAX)		Document abstract.
Document abstract.
	12	Document	varbinary(MAX)		Complete document.
Complete document.
	13	rowguid	uniqueidentifier	Default: newid()	ROWGUIDCOL number uniquely identifying the record. Required for FileStream.
ROWGUIDCOL number uniquely identifying the record. Required for FileStream. Default: newid()
	14	ModifiedDate	datetime	Default: getdate()	Date and time the record was last updated.
Date and time the record was last updated. Default: getdate()

Relations

Foreign table		Primary table	Join	Title / Name / Description
Production.ProductDocument		Production.Document	Production.ProductDocument.DocumentNode = Production.Document.DocumentNode	FK_ProductDocument_Document_DocumentNode Foreign key constraint referencing Document.DocumentNode.
Production.ProductDocument.DocumentNode = Production.Document.DocumentNode Name: FK_ProductDocument_Document_DocumentNode Foreign key constraint referencing Document.DocumentNode.

Unique keys

	Key name	Columns	Description
	PK_Document_DocumentNode	DocumentNode	Primary key (clustered) constraint
Primary key (clustered) constraint
	AK_Document_DocumentLevel_DocumentNode	DocumentLevel, DocumentNode	Unique nonclustered index.
Unique nonclustered index.
	AK_Document_rowguid	rowguid	Unique nonclustered index. Used to support FileStream.
Unique nonclustered index. Used to support FileStream.
	UQ__Document__F73921F793071A63	rowguid

Uses

Name
Production.Document
Production.Document

Used by

Name
Production.Document
Production.Document
Production.ProductDocument

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56