Production |
04/26/2006 |
PRIMARY |
344 |
24 |
9 |
Product maintenance documents. |
|
|
DocumentID |
int |
4 |
|
|
|
|
Primary key for Document records. |
|
|
Title |
nvarchar |
50 |
|
|
|
|
Title of the document. |
|
|
FileName |
nvarchar |
400 |
|
|
|
|
Directory path and file name of the document |
|
|
FileExtension |
nvarchar |
8 |
|
|
|
|
File extension indicating the document type. For example, .doc or .txt. |
|
|
Revision |
nchar |
5 |
|
|
|
|
Revision number of the document. |
|
|
ChangeNumber |
int |
4 |
|
((0)) |
|
|
Engineering change approval number. |
|
|
Status |
tinyint |
1 |
|
|
|
|
1 = Pending approval, 2 = Approved, 3 = Obsolete |
|
|
DocumentSummary |
nvarchar |
-0.5 |
|
|
|
|
Document abstract. |
|
|
Document |
varbinary |
-1 |
|
|
|
|
Complete document. |
|
|
ModifiedDate |
datetime |
8 |
|
(getdate()) |
|
|
Date and time the record was last updated. |
Total: 10 column(s)
|
DocumentID |
1 |
1 |
|
Total: 2 index(es)
|
CK_Document_Status |
([Status]>=(1) AND [Status]<=(3)) |
Total: 1 constraint(s)
Total: 1 table(s)
Total: 1 object(s)
CREATE TABLE [Document] (
[DocumentID] [int] IDENTITY (1, 1) NOT NULL ,
[Title] [nvarchar] (50) COLLATE Latin1_General_CS_AS NOT NULL ,
[FileName] [nvarchar] (400) COLLATE Latin1_General_CS_AS NOT NULL ,
[FileExtension] [nvarchar] (8) COLLATE Latin1_General_CS_AS NOT NULL ,
[Revision] [nchar] (5) COLLATE Latin1_General_CS_AS NOT NULL ,
[ChangeNumber] [int] NOT NULL CONSTRAINT [DF_Document_ChangeNumber] DEFAULT ((0)),
[Status] [tinyint] NOT NULL ,
[DocumentSummary] [nvarchar] (0) COLLATE Latin1_General_CS_AS NULL ,
[Document] [varbinary] (-1) NULL ,
[ModifiedDate] [datetime] NOT NULL CONSTRAINT [DF_Document_ModifiedDate] DEFAULT (getdate()),
CONSTRAINT [PK_Document_DocumentID] PRIMARY KEY CLUSTERED
(
[DocumentID]
) ON [PRIMARY] ,
CONSTRAINT [CK_Document_Status] CHECK ([Status]>=(1) AND [Status]<=(3))
) ON [PRIMARY]
GO
List of tables