ScrewTurn Wiki

Edit

wikibot

TableProduction.Document
DescriptionProduct maintenance documents.

Edit

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.

Edit

Primary Key

Primary KeyColumns
PK_Document_DocumentIDDocumentID

Edit

Indexes

IndexTypeColumns
AK_Document_FileName_RevisionUniqueFileName, Revision

Edit

Check Constraints

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

Edit

Detail Tables

Detail TableColumnReferencing Column
Production.ProductDocumentDocumentIDDocumentID

Edit

References

Dependency TypeObject TypeReferenced Object
SchemaSchemaProduction

Edit

automatically generated

TableProduction.Document
DescriptionProduct maintenance documents.

ColumnData TypeNullableDefaultDescription / PK / Index
DocumentIDintnot null Primary key for Document records.
PK_Document_DocumentID
Titlenvarchar(50)not null Title of the document.
FileNamenvarchar(400)not null Directory path and file name of the document
AK_Document_FileName_Revision
FileExtensionnvarchar(8)not null File extension indicating the document type. For example, .doc or .txt.
Revisionnchar(5)not null Revision number of the document.
AK_Document_FileName_Revision
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.



Detail TableColumnReferencing Column
Production.ProductDocumentDocumentIDDocumentID

Dependency TypeObject TypeReferenced Object
SchemaSchemaProduction

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