Production.Document Table

Description

Product maintenance documents.

Properties

Creation Date	08/01/2010 08:40
File Group	PRIMARY
Text File Group	PRIMARY
System Object
Published for Replication
Rows	9
Data Space Used	344.00 KB
Index Space Used	24.00 KB

Columns

Column Name	Description	Datatype	Length	Default
DocumentID	Primary key for Document records.	int	4
Title	Title of the document.	nvarchar	50
FileName	Directory path and file name of the document	nvarchar	400
FileExtension	File extension indicating the document type. For example, .doc or .txt.	nvarchar	8
Revision	Revision number of the document.	nchar	5
ChangeNumber	Engineering change approval number.	int	4	((0))
Status	1 = Pending approval, 2 = Approved, 3 = Obsolete	tinyint	1
DocumentSummary	Document abstract.	nvarchar	16
Document	Complete document.	varbinary	16
ModifiedDate	Date and time the record was last updated.	datetime	4	(getdate())

Indexes

Index	Description	Primary	Unique
AK_Document_FileName_Revision	Unique nonclustered index.
PK_Document_DocumentID	Primary key (clustered) constraint

Check Constraints

Name	Description	Expression
CK_Document_Status	Check constraint [Status] BETWEEN (1) AND (3)	([Status]>=(1) AND [Status]<=(3))

Relationships

Relationship	Description
FK_ProductDocument_Document_DocumentID	Foreign key constraint referencing Document.DocumentID.

Objects that depend on Production.Document

	Database Object	Object Type	Description	Dep Level
	Production.ProductDocument	Table	Cross-reference table mapping products to related product documents.	1

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [Production].[Document](
	[DocumentID] [int] IDENTITY(1,1) NOT NULL,
	[Title] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[FileName] [nvarchar](400) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[FileExtension] [nvarchar](8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[Revision] [nchar](5) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[ChangeNumber] [int] NOT NULL,
	[Status] [tinyint] NOT NULL,
	[DocumentSummary] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
	[Document] [varbinary](max) NULL,
	[ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Document_DocumentID] PRIMARY KEY CLUSTERED 
(
	[DocumentID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

ALTER TABLE [Production].[Document]  WITH CHECK ADD  CONSTRAINT [CK_Document_Status] CHECK  (([Status]>=(1) AND [Status]<=(3)))
ALTER TABLE [Production].[Document] CHECK CONSTRAINT [CK_Document_Status]
ALTER TABLE [Production].[Document] ADD  CONSTRAINT [DF_Document_ChangeNumber]  DEFAULT ((0)) FOR [ChangeNumber]
ALTER TABLE [Production].[Document] ADD  CONSTRAINT [DF_Document_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]

Related Objects