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

From dbscript Online Help
Jump to: navigation, search
 
(2 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
 
| '''Table
 
| '''Table
 
| Production.Document
 
| Production.Document
Line 8: Line 8:
 
| '''Description
 
| '''Description
 
| Product maintenance documents.
 
| Product maintenance documents.
−
|-
 
 
|}
 
|}
  
−
 
+
=== Columns ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 18: Line 17:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''Description / PK / Index
+
| '''Description
−
+
 
 
|- valign="top"
 
|- valign="top"
 
| DocumentID
 
| DocumentID
Line 25: Line 24:
 
| not null
 
| not null
 
|  
 
|  
−
| Primary key for Document records.<br />PK_Document_DocumentID
+
| Primary key for Document records.
 
|- valign="top"
 
|- valign="top"
 
| Title
 
| Title
Line 31: Line 30:
 
| not null
 
| not null
 
|  
 
|  
−
| Title of the document.<br />
+
| Title of the document.
 
|- valign="top"
 
|- valign="top"
 
| FileName
 
| FileName
Line 37: Line 36:
 
| not null
 
| not null
 
|  
 
|  
−
| Directory path and file name of the document<br />AK_Document_FileName_Revision
+
| Directory path and file name of the document
 
|- valign="top"
 
|- valign="top"
 
| FileExtension
 
| FileExtension
Line 43: Line 42:
 
| not null
 
| not null
 
|  
 
|  
−
| File extension indicating the document type. For example, .doc or .txt.<br />
+
| File extension indicating the document type. For example, .doc or .txt.
 
|- valign="top"
 
|- valign="top"
 
| Revision
 
| Revision
Line 49: Line 48:
 
| not null
 
| not null
 
|  
 
|  
−
| Revision number of the document. <br />AK_Document_FileName_Revision
+
| Revision number of the document.  
 
|- valign="top"
 
|- valign="top"
 
| ChangeNumber
 
| ChangeNumber
Line 55: Line 54:
 
| not null
 
| not null
 
| ((0))
 
| ((0))
−
| Engineering change approval number.<br />
+
| Engineering change approval number.
 
|- valign="top"
 
|- valign="top"
 
| Status
 
| Status
Line 61: Line 60:
 
| not null
 
| not null
 
|  
 
|  
−
| 1 = Pending approval, 2 = Approved, 3 = Obsolete<br />
+
| 1 = Pending approval, 2 = Approved, 3 = Obsolete
 
|- valign="top"
 
|- valign="top"
 
| DocumentSummary
 
| DocumentSummary
Line 67: Line 66:
 
| null
 
| null
 
|  
 
|  
−
| Document abstract.<br />
+
| Document abstract.
 
|- valign="top"
 
|- valign="top"
 
| Document
 
| Document
Line 73: Line 72:
 
| null
 
| null
 
|  
 
|  
−
| Complete document.<br />
+
| Complete document.
 
|- valign="top"
 
|- valign="top"
 
| ModifiedDate
 
| ModifiedDate
Line 79: Line 78:
 
| not null
 
| not null
 
| (getdate())
 
| (getdate())
−
| Date and time the record was last updated.<br />
+
| 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"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 89: Line 123:
 
| '''Column
 
| '''Column
 
| '''Referencing Column
 
| '''Referencing Column
−
+
 
−
|-
+
|- valign="top"
 
| [[Production.ProductDocument_(table)|Production.ProductDocument]]
 
| [[Production.ProductDocument_(table)|Production.ProductDocument]]
 
| DocumentID
 
| DocumentID
Line 96: Line 130:
 
|}
 
|}
  
 +
=== 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]]
 +
 +
|}
  
  

Latest revision as of 23:16, 23 June 2010

wikibot[edit]

Table Production.Document
Description Product maintenance documents.

Columns[edit]

Column Data Type Nullable Default Description
DocumentID int not null Primary key for Document records.
Title nvarchar(50) not null Title of the document.
FileName nvarchar(400) not null Directory path and file name of the document
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.
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.

Primary Key[edit]

Primary Key Columns
PK_Document_DocumentID DocumentID

Indexes[edit]

Index Type Columns
AK_Document_FileName_Revision Unique FileName, Revision

Check Constraints[edit]

Check Constraint Expression Description
CK_Document_Status ([Status]>=(1) AND [Status]<=(3)) Check constraint [Status] BETWEEN (1) AND (3)

Detail Tables[edit]

Detail Table Column Referencing Column
Production.ProductDocument DocumentID DocumentID

References[edit]

Dependency Type Object Type Referenced Object
Schema Schema Production


automatically generated[edit]

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


Dependency Type Object Type Referenced Object
Schema Schema Production
Retrieved from "http://dbshelp.devio.at/index.php?title=Production.Document_(table)&oldid=2623"