Production.Document (table) - Revision history

Bot at 22:16, 23 June 2010

2010-06-23T22:16:30Z

Bot at 22:05, 2 February 2010

2010-02-02T22:05:10Z

Bot at 21:52, 2 February 2010

2010-02-02T21:52:29Z

Bot at 21:54, 28 December 2009

2009-12-28T21:54:27Z

Bot at 05:59, 30 November 2009

2009-11-30T05:59:13Z

Bot at 05:34, 30 November 2009

2009-11-30T05:34:34Z

Bot at 05:33, 30 November 2009

2009-11-30T05:33:26Z

Bot at 05:31, 30 November 2009

2009-11-30T05:31:53Z

Bot at 05:24, 30 November 2009

2009-11-30T05:24:42Z

Bot at 23:12, 26 November 2009

2009-11-26T23:12:43Z

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Production.Document
@@ Line 8: / Line 8: @@
 | '''Description
 | Product maintenance documents.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | DocumentID
@@ Line 88: / Line 86: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_Document_DocumentID
 | DocumentID
@@ Line 99: / Line 97: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | AK_Document_FileName_Revision
 | Unique
@@ Line 112: / Line 110: @@
 | '''Expression
 | '''Description
-−
-|-
+|- valign="top"
 | CK_Document_Status
 | ([Status]>=(1) AND [Status]<=(3))
@@ Line 125: / Line 123: @@
 | '''Column
 | '''Referencing Column
-−
-|-
+|- valign="top"
 | [[Production.ProductDocument_(table)|Production.ProductDocument]]
 | DocumentID
@@ Line 139: / Line 137: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Schema
 | Schema

@@ Line 130: / Line 130: @@
 | DocumentID
 | DocumentID
 |}

@@ Line 12: / Line 12: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 18: / Line 19: @@
 | '''Nullable
 | '''Default
-| '''Description / PK / Index
+| '''Description
 |- valign="top"
@@ Line 25: / Line 26: @@
 | not null
+|
-| Primary key for Document records.<br />PK_Document_DocumentID
+| Primary key for Document records.
 |- valign="top"
 | Title
@@ Line 31: / Line 32: @@
 | not null
+|
-| Title of the document.<br />
+| Title of the document.
 |- valign="top"
 | FileName
@@ Line 37: / Line 38: @@
 | 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"
 | FileExtension
@@ Line 43: / Line 44: @@
 | 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"
 | Revision
@@ Line 49: / Line 50: @@
 | not null
+|
-| Revision number of the document. <br />AK_Document_FileName_Revision
+| Revision number of the document.
 |- valign="top"
 | ChangeNumber
@@ Line 55: / Line 56: @@
 | not null
 | ((0))
-| Engineering change approval number.<br />
+| Engineering change approval number.
 |- valign="top"
 | Status
@@ Line 61: / Line 62: @@
 | not null
+|
-| 1 = Pending approval, 2 = Approved, 3 = Obsolete<br />
+| 1 = Pending approval, 2 = Approved, 3 = Obsolete
 |- valign="top"
 | DocumentSummary
@@ Line 67: / Line 68: @@
 | null
+|
-| Document abstract.<br />
+| Document abstract.
 |- valign="top"
 | Document
@@ Line 73: / Line 74: @@
 | null
+|
-| Complete document.<br />
+| Complete document.
 |- valign="top"
 | ModifiedDate
@@ Line 79: / Line 80: @@
 | not null
 | (getdate())
-| Date and time the record was last updated.<br />
+| Date and time the record was last updated.
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 95: / Line 131: @@
 | DocumentID
 |}

@@ Line 5: / Line 5: @@
 | '''Table
 | Production.Document
 |-
 |}
@@ Line 15: / Line 18: @@
 | '''Nullable
 | '''Default
-| '''PK
+| '''Description / PK / Index
-|-
+|- valign="top"
 | DocumentID
 | int
 | not null
+|
-| PK_Document_DocumentID
+| Primary key for Document records.<br />PK_Document_DocumentID
+|- valign="top"
 | Title
 | nvarchar(50)
 | not null
+|
+| Title of the document.<br />
+|- valign="top"
 | FileName
 | nvarchar(400)
 | not null
+|
+| Directory path and file name of the document<br />AK_Document_FileName_Revision
-| AK_Document_FileName_Revision
+|- valign="top"
 | FileExtension
 | nvarchar(8)
 | not null
+|
+| File extension indicating the document type. For example, .doc or .txt.<br />
+|- valign="top"
 | Revision
 | nchar(5)
 | not null
+|
+| Revision number of the document. <br />AK_Document_FileName_Revision
-| AK_Document_FileName_Revision
+|- valign="top"
 | ChangeNumber
 | int
 | not null
 | ((0))
+| Engineering change approval number.<br />
+|- valign="top"
 | Status
 | tinyint
 | not null
+|
+| 1 = Pending approval, 2 = Approved, 3 = Obsolete<br />
+|- valign="top"
 | DocumentSummary
 | nvarchar(max)
 | null
+|
+| Document abstract.<br />
+|- valign="top"
 | Document
 | varbinary(max)
 | null
+|
+| Complete document.<br />
+|- valign="top"
 | ModifiedDate
 | datetime
 | not null
 | (getdate())
+| Date and time the record was last updated.<br />
 |}
@@ Line 103: / Line 95: @@
 | DocumentID
 |}
 == automatically generated ==

@@ Line 110: / Line 110: @@
 | Production.Document
 |- valign="top"
 | '''Description
 | Product maintenance documents.
 |-
 |}

@@ Line 212: / Line 212: @@
 | Schema
 | Schema
-| [[Production_(schema)|false.Production]]
+| [[Production_(schema)|Production]]
 |}