Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Production Document (table)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/01/09 18:01


wikibot

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

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