From dbscript Online Help
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())
|
|
|
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 documentAK_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.
|