Properties

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

Columns

		Name	Data Type	Length	NULL	Default	IsIdentity	IsGUID	Description
		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)

Identity column

	Name	Seed	Increment	Not for replication
	DocumentID	1	1

Indexes

	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	1

Total: 1 object(s)

SQL

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

See Also

List of tables