Difference between revisions of "Production.Document (table)"

From dbscript Online Help
Jump to: navigation, search
Line 87: Line 87:
 
| (getdate())
 
| (getdate())
 
|  
 
|  
 +
|
 +
|}
 +
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Detail Table
 +
| '''Column
 +
| '''Referencing Column
 +
 +
|-
 +
| [[Production.ProductDocument_(table)|Production.ProductDocument]]
 +
| DocumentID
 +
| DocumentID
 +
|}
 +
 +
== automatically generated ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''Table
 +
| Production.Document
 +
|-
 +
 +
| '''Description
 +
| Product maintenance documents.
 +
|-
 +
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Column
 +
| '''Data Type
 +
| '''Nullable
 +
| '''Default
 +
| '''Description
 +
| '''PK / Index
 +
 +
|-
 +
| DocumentID
 +
| int
 +
| not null
 +
|
 +
| Primary key for Document records.
 +
| PK_Document_DocumentID
 +
|-
 +
| Title
 +
| nvarchar(50)
 +
| not null
 +
|
 +
| Title of the document.
 +
|
 +
|-
 +
| FileName
 +
| nvarchar(400)
 +
| not null
 +
|
 +
| Directory path and file name of the document
 +
| AK_Document_FileName_Revision
 +
|-
 +
| FileExtension
 +
| nvarchar(8)
 +
| not null
 +
|
 +
| File extension indicating the document type. For example, .doc or .txt.
 +
|
 +
|-
 +
| Revision
 +
| nchar(5)
 +
| not null
 +
|
 +
| Revision number of the document.
 +
| AK_Document_FileName_Revision
 +
|-
 +
| ChangeNumber
 +
| int
 +
| not null
 +
| (0)
 +
| Engineering change approval number.
 +
|
 +
|-
 +
| Status
 +
| tinyint
 +
| not null
 +
|
 +
| 1 = Pending approval, 2 = Approved, 3 = Obsolete
 +
|
 +
|-
 +
| DocumentSummary
 +
| nvarchar(max)
 +
| null
 +
|
 +
| Document abstract.
 +
|
 +
|-
 +
| Document
 +
| varbinary(max)
 +
| null
 +
|
 +
| Complete document.
 +
|
 +
|-
 +
| ModifiedDate
 +
| datetime
 +
| not null
 +
| (GETDATE())
 +
| Date and time the record was last updated.
 
|  
 
|  
 
|}
 
|}

Revision as of 23:26, 26 November 2009

wikibot

Table Production.Document


Column Data Type Nullable Default PK Index
DocumentID int not null PK_Document_DocumentID
Title nvarchar(50) not null
FileName nvarchar(400) not null AK_Document_FileName_Revision
FileExtension nvarchar(8) not null
Revision nchar(5) not null AK_Document_FileName_Revision
ChangeNumber int not null ((0))
Status tinyint not null
DocumentSummary nvarchar(max) null
Document varbinary(max) null
ModifiedDate datetime not null (getdate())


Detail Table Column Referencing Column
Production.ProductDocument DocumentID DocumentID

automatically generated

Table Production.Document
Description Product maintenance documents.


Column Data Type Nullable Default Description PK / Index
DocumentID int not null Primary key for Document records. PK_Document_DocumentID
Title nvarchar(50) not null Title of the document.
FileName nvarchar(400) not null Directory path and file name of the document AK_Document_FileName_Revision
FileExtension nvarchar(8) not null File extension indicating the document type. For example, .doc or .txt.
Revision nchar(5) not null Revision number of the document. AK_Document_FileName_Revision
ChangeNumber int not null (0) Engineering change approval number.
Status tinyint not null 1 = Pending approval, 2 = Approved, 3 = Obsolete
DocumentSummary nvarchar(max) null Document abstract.
Document varbinary(max) null Complete document.
ModifiedDate datetime not null (GETDATE()) Date and time the record was last updated.


Detail Table Column Referencing Column
Production.ProductDocument DocumentID DocumentID
Retrieved from "http://dbshelp.devio.at/index.php?title=Production.Document_(table)&oldid=1090"