Production.Document

Field Name Data Type Size Original Type Default Nullable Description Check

DocumentID int identity 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 (0) Not null Engineering change approval number.

Status tinyint Not null 1 = Pending approval, 2 = Approved, 3 = Obsolete ([Status]>=(1) AND [Status]<=(3))

DocumentSummary nvarchar max Null Document abstract.

Document varbinary Null Complete document.

ModifiedDate datetime getdate() Not null Date and time the record was last updated.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
DocumentID	int identity		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			(0)	Not null	Engineering change approval number.
Status	tinyint				Not null	1 = Pending approval, 2 = Approved, 3 = Obsolete	([Status]>=(1) AND [Status]<=(3))
DocumentSummary	nvarchar	max			Null	Document abstract.
Document	varbinary				Null	Complete document.
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'Production.Document'

Primary Key Name Field Name

PK_Document_DocumentID DocumentID

There are no Foreign Keys for this table.

Primary Key Name	Field Name
PK_Document_DocumentID	DocumentID

Indexes for table 'Production.Document', 2 items

Index Name Description Clustered Unique Fields

PK_Document_DocumentID Clustered index created by a primary key constraint. Yes Yes DocumentID

AK_Document_FileName_Revision Unique nonclustered index. No Yes FileName, Revision

Index Name	Description	Clustered	Unique	Fields
PK_Document_DocumentID	Clustered index created by a primary key constraint.	Yes	Yes	DocumentID
AK_Document_FileName_Revision	Unique nonclustered index.	No	Yes	FileName, Revision

Triggers for table 'Production.Document', 1 item

Name Description Type Enabled

uDocument AFTER UPDATE trigger setting the ModifiedDate column in the Document table to the current date. after Update Yes

Name	Description	Type	Enabled
uDocument	AFTER UPDATE trigger setting the ModifiedDate column in the Document table to the current date.	after Update	Yes

Dependencies for table 'Production.Document', 2 items

Object Name Type Field Name

Production.CK_Document_Status check cns N/A

Production.uDocument trigger N/A