Owner: Production 
Creation Date: 04/26/2006 
Located On: PRIMARY 
Data Size KB: 344 
Index Size KB: 24 
Description: Product maintenance documents. 


Name Data Type Length NULL Default IsIdentity IsGUID Description
    DocumentID  int          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          File extension indicating the document type. For example, .doc or .txt. 
    Revision  nchar          Revision number of the document.  
    ChangeNumber  int    ((0))      Engineering change approval number. 
    Status  tinyint          1 = Pending approval, 2 = Approved, 3 = Obsolete 
    DocumentSummary  nvarchar  -0.5          Document abstract. 
    Document  varbinary  -1          Complete document. 
    ModifiedDate  datetime    (getdate())      Date and time the record was last updated. 
Total: 10 column(s)

Identity column

Name Seed Increment Not for replication


Index Primary Unique Description
  PK_Document_DocumentID      Primary key (clustered) constraint 
  AK_Document_FileName_Revision      Unique nonclustered index. 
Total: 2 index(es)

Check Constraints

Name Expression
  CK_Document_Status  ([Status]>=(1) AND [Status]<=(3)) 
Total: 1 constraint(s)

Referencing Tables

Table Foreign Key Primary Key or Unique Constraint
  Production.ProductDocument  FK_ProductDocument_Document_DocumentID  PK_Document_DocumentID 
Total: 1 table(s)

Objects that depend on [Production].[Document]

Object Name Owner Object Type Dep Level
  ProductDocument  Production  Table 
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()),
    )  ON [PRIMARY] ,
    CONSTRAINT [CK_Document_Status] CHECK ([Status]>=(1) AND [Status]<=(3))

See Also

List of tables