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

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Production.Document |- |} {| border="1" cellpadding="5" cellspacing="0" styl...)
 
 
(13 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
== wikibot ==
 
== 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
 +
|
 +
| Primary key for Document records.
 +
|- valign="top"
 +
| Title
 +
| nvarchar(50)
 +
| not null
 +
|
 +
| Title of the document.
 +
|- valign="top"
 +
| FileName
 +
| nvarchar(400)
 +
| not null
 +
|
 +
| Directory path and file name of the document
 +
|- valign="top"
 +
| FileExtension
 +
| nvarchar(8)
 +
| not null
 +
|
 +
| File extension indicating the document type. For example, .doc or .txt.
 +
|- valign="top"
 +
| Revision
 +
| nchar(5)
 +
| not null
 +
|
 +
| Revision number of the document.
 +
|- valign="top"
 +
| ChangeNumber
 +
| int
 +
| not null
 +
| ((0))
 +
| Engineering change approval number.
 +
|- valign="top"
 +
| Status
 +
| tinyint
 +
| not null
 +
|
 +
| 1 = Pending approval, 2 = Approved, 3 = Obsolete
 +
|- valign="top"
 +
| DocumentSummary
 +
| nvarchar(max)
 +
| null
 +
|
 +
| Document abstract.
 +
|- valign="top"
 +
| Document
 +
| varbinary(max)
 +
| null
 +
|
 +
| 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]]
 +
 +
|}
 +
 +
 +
== automatically generated ==
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
Line 5: Line 151:
 
| '''Table
 
| '''Table
 
| Production.Document
 
| Production.Document
 +
|- valign="top"
 +
| '''Description
 +
| Product maintenance documents.
 
|-
 
|-
 
|}
 
|}
Line 15: Line 164:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description / PK / Index
−
| '''Index
 
 
 
−
|-
+
|- valign="top"
 
| DocumentID
 
| DocumentID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_Document_DocumentID
+
| Primary key for Document records.<br />PK_Document_DocumentID
−
|
+
|- valign="top"
−
|-
 
 
| Title
 
| Title
 
| nvarchar(50)
 
| nvarchar(50)
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Title of the document.<br />
−
|
+
|- valign="top"
−
|-
 
 
| FileName
 
| FileName
 
| nvarchar(400)
 
| nvarchar(400)
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Directory path and file name of the document<br />AK_Document_FileName_Revision
−
| AK_Document_FileName_Revision
+
|- valign="top"
−
|-
 
 
| FileExtension
 
| FileExtension
 
| nvarchar(8)
 
| nvarchar(8)
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| File extension indicating the document type. For example, .doc or .txt.<br />
−
|
+
|- valign="top"
−
|-
 
 
| Revision
 
| Revision
−
| nchar(0)
+
| nchar(5)
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Revision number of the document. <br />AK_Document_FileName_Revision
−
| AK_Document_FileName_Revision
+
|- valign="top"
−
|-
 
 
| ChangeNumber
 
| ChangeNumber
 
| int
 
| int
 
| not null
 
| not null
−
| ((0))
+
| (0)
−
|
+
| Engineering change approval number.<br />
−
|  
+
|- valign="top"
−
|-
 
 
| Status
 
| Status
 
| tinyint
 
| tinyint
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| 1 = Pending approval, 2 = Approved, 3 = Obsolete<br />
−
|
+
|- valign="top"
−
|-
 
 
| DocumentSummary
 
| DocumentSummary
 
| nvarchar(max)
 
| nvarchar(max)
 
| null
 
| null
 
|  
 
|  
−
|  
+
| Document abstract.<br />
−
|
+
|- valign="top"
−
|-
 
 
| Document
 
| Document
 
| varbinary(max)
 
| varbinary(max)
 
| null
 
| null
 
|  
 
|  
−
|  
+
| Complete document.<br />
−
|
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
−
| (getdate())
+
| (GETDATE())
−
|  
+
| Date and time the record was last updated.<br />
−
|
 
 
|}
 
|}
  
Line 102: Line 240:
 
| DocumentID
 
| DocumentID
 
| DocumentID
 
| DocumentID
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|-
 +
| 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"