Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

wikibot

TableProduction.Document
DescriptionProduct maintenance documents.

Columns

ColumnData TypeNullableDefaultDescription
DocumentIDintnot null Primary key for Document records.
Titlenvarchar(50)not null Title of the document.
FileNamenvarchar(400)not null Directory path and file name of the document
FileExtensionnvarchar(8)not null File extension indicating the document type. For example, .doc or .txt.
Revisionnchar(5)not null Revision number of the document.
ChangeNumberintnot null((0))Engineering change approval number.
Statustinyintnot null 1 = Pending approval, 2 = Approved, 3 = Obsolete
DocumentSummarynvarchar(max)null Document abstract.
Documentvarbinary(max)null Complete document.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Primary Key

Primary KeyColumns
PK_Document_DocumentIDDocumentID

Indexes

IndexTypeColumns
AK_Document_FileName_RevisionUniqueFileName, Revision

Check Constraints

Check ConstraintExpressionDescription
CK_Document_Status(Status>=(1) AND Status<=(3))Check constraint Status BETWEEN (1) AND (3)

Detail Tables

Detail TableColumnReferencing Column
Production.ProductDocumentDocumentIDDocumentID

References

Dependency TypeObject TypeReferenced Object
SchemaSchemaProduction

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.