Table: 'Production.Document'

10 fields. 951 bytes.

Product maintenance documents.

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
DocumentIDint identity int Not nullPrimary key for Document records. 
Titlenvarchar50  Not nullTitle of the document. 
FileNamenvarchar400  Not nullDirectory path and file name of the document 
FileExtensionnvarchar8  Not nullFile extension indicating the document type. For example, .doc or .txt. 
Revisionnchar5  Not nullRevision number of the document.  
ChangeNumberint  (0)Not nullEngineering change approval number. 
Statustinyint   Not null1 = Pending approval, 2 = Approved, 3 = Obsolete([Status]>=(1) AND [Status]<=(3))
DocumentSummarynvarcharmax  NullDocument abstract. 
Documentvarbinary   NullComplete document. 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'Production.Document'

Primary Key NameField Name
There are no Foreign Keys for this table.

Indexes for table 'Production.Document', 2 items

Index NameDescriptionClusteredUniqueFields
PK_Document_DocumentIDClustered index created by a primary key constraint.YesYesDocumentID
AK_Document_FileName_RevisionUnique nonclustered index.NoYesFileName, Revision

Triggers for table 'Production.Document', 1 item

uDocumentAFTER 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 NameTypeField Name
Production.CK_Document_Statuscheck cnsN/A