Production Document (table)

Modified on 2011/08/27 11:17 by wikibot Categorized as Uncategorized
== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Table'''
| Production.Document
|- valign="top"
| '''Description'''
| Product maintenance documents.
|}

=== Columns ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Column'''
| '''Data Type'''
| '''Nullable'''
| '''Default'''
| '''Description'''

|- valign="top"
| DocumentID
| int
| not null
| &nbsp;
| Primary key for Document records.
|- valign="top"
| Title
| nvarchar(50)
| not null
| &nbsp;
| Title of the document.
|- valign="top"
| FileName
| nvarchar(400)
| not null
| &nbsp;
| Directory path and file name of the document
|- valign="top"
| FileExtension
| nvarchar(8)
| not null
| &nbsp;
| File extension indicating the document type. For example, .doc or .txt.
|- valign="top"
| Revision
| nchar(5)
| not null
| &nbsp;
| Revision number of the document. 
|- valign="top"
| ChangeNumber
| int
| not null
| ((0))
| Engineering change approval number.
|- valign="top"
| Status
| tinyint
| not null
| &nbsp;
| 1 = Pending approval, 2 = Approved, 3 = Obsolete
|- valign="top"
| DocumentSummary
| nvarchar(max)
| null
| &nbsp;
| Document abstract.
|- valign="top"
| Document
| varbinary(max)
| null
| &nbsp;
| Complete document.
|- valign="top"
| ModifiedDate
| datetime
| not null
| (getdate())
| Date and time the record was last updated.
|}

=== Primary Key ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Primary Key'''
| '''Columns'''
|- valign="top"
| PK_Document_DocumentID
| DocumentID
|}

=== Indexes ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Index'''
| '''Type'''
| '''Columns'''

|- valign="top"
| AK_Document_FileName_Revision
| Unique
| FileName, Revision
|}

=== Check Constraints ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Check Constraint'''
| '''Expression'''
| '''Description'''

|- valign="top"
| CK_Document_Status
| ([Status]>=(1) AND [Status]<=(3))
| Check constraint [Status] BETWEEN (1) AND (3)
|}

=== Detail Tables ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Detail Table'''
| '''Column'''
| '''Referencing Column'''

|- valign="top"
| [[Production ProductDocument (table)|Production.ProductDocument]]
| DocumentID
| DocumentID
|}

=== References ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Dependency Type'''
| '''Object Type'''
| '''Referenced Object'''

|- valign="top"
| Schema
| Schema
| [[Production (schema)|Production]]

|}
devio dbscript ScrewTurn Wiki

Navigation¶

Production Document (table)
