table icon Table: Document

Properties

Property Value
Name Document
ID 789577851
Owner dbo
Schema Production
Filegroup PRIMARY
Data Size (KB) 8 KB
Index Size (KB) 176 KB
Rows 13
Unused (KB) 0 KB
ANSI Null On true
Quoted Identifier true
Lock Escalation TABLE
Lock On Bulk Load false
Lob Data Space PRIMARY
Filestream Data Space ID 2
Has Unchecked Assembly Data false
Text In Row Limit (bytes) Option not set
Large Value Types Out Of Row false
FullText Change Tracking On true
Tracked By Cdc false
Published false
Schema Published false
Replicated false
Replication Filter false
Merge Published false
Sync Tran Subscribed false
MS Shipped false
Modify Date 8/8/2010 5:23:39 PM
Create Date 8/8/2010 5:21:51 PM

Extended Properties

Name Value
MS_Description Product maintenance documents.

Columns

Column ID Column Name Datatype Nullable Is Sparse Is Column Set
1 DocumentNode hierarchyid false false false
2 DocumentLevel smallint true false false
3 Title nvarchar(50) false false false
4 Owner int false false false
5 FolderFlag bit false false false
6 FileName nvarchar(400) false false false
7 FileExtension nvarchar(8) false false false
8 Revision nchar(5) false false false
9 ChangeNumber int false false false
10 Status tinyint false false false
11 DocumentSummary nvarchar(max) true false false
12 Document varbinary(max) true false false
13 rowguid uniqueidentifier false false false
14 ModifiedDate datetime false false false

Identity Columns

No identity columns defined.

Primary Key Constraints

Name Is System Named Extended Property Name Extended Property Value
PK_Document_DocumentNode false MS_Description Primary key (clustered) constraint

Primary Key Columns

Name
DocumentNode

Foreign Keys

Name Referenced Object Update Action Delete Action
FK_Document_Employee_Owner HumanResources.Employee No action No action

Column Level Check Constraints

Name Column ID Column Definition Is Disabled Is Not For Replication Is Not Trusted Uses Database Collation Is System Named
CK_Document_Status 10 Status ([Status]>=(1) AND [Status]<=(3)) false false false true false

Table Level Check Constraints

No table constraints defined.

Default Constraints

Name Column Definition Is System Named Extended Property Name Extended Property Value
DF_Document_FolderFlag FolderFlag ((0)) false
DF_Document_ChangeNumber ChangeNumber ((0)) false MS_Description Default constraint value of 0
DF_Document_rowguid rowguid (newid()) false MS_Description Default constraint value of NEWID()
DF_Document_ModifiedDate ModifiedDate (getdate()) false MS_Description Default constraint value of GETDATE()

Indexes

Name Index Type Primary Key Unique Unique Constraint Ignore Duplicate Key Disabled
PK_Document_DocumentNode CLUSTERED true true false false false
UQ__Document__F73921F730F848ED NONCLUSTERED false true true false false
AK_Document_DocumentLevel_DocumentNode NONCLUSTERED false true false false false
AK_Document_rowguid NONCLUSTERED false true false false false
IX_Document_FileName_Revision NONCLUSTERED false false false false false

FullText Indexes

Name Corresponding Unique Index Name Is Enabled Change Tracking State Description
FullText Index PK_Document_DocumentNode true Auto

Referencing Tables

Name Key Index ID Is Disabled Is Not For Replication Is Not Trusted Delete Action Update Action Is System Named Referencing Object
FK_ProductDocument_Document_DocumentNode 1 false false false No action No action false Production.ProductDocument

Object Level Permissions

No object level permissions defined.

Column Level Permissions

No explicit column permissions granted to this object

Statistics

Detailed Statistics General

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
PK_Document_DocumentNode Aug 8 2010 5:22PM 13 13 7 1 1.615385 false 13

Detailed Statistics Density

All Density Average Length Columns
0.07692308 1.615385 DocumentNode

Detailed Statistics Histogram

Range High Key Range Rows Estimated Rows Distinct Range Rows Avg Range Rows
/ 0 1 0 1
/1/1/ 1 1 1 1
/2/ 1 1 1 1
/2/2/ 1 1 1 1
/3/1/ 1 1 1 1
/3/3/ 1 1 1 1
/3/5/ 1 1 1 1

Detailed Statistics General

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
UQ__Document__F73921F730F848ED Aug 8 2010 5:22PM 13 13 13 0 17.61539 false 13

Detailed Statistics Density

All Density Average Length Columns
0.07692308 16 rowguid
0.07692308 17.61539 rowguid, DocumentNode

Detailed Statistics Histogram

Range High Key Range Rows Estimated Rows Distinct Range Rows Avg Range Rows
d11b82b0-eb40-4a66-8193-15f765a61f05 0 1 0 1
79d41fe8-39d7-4591-9a05-285a3e1aafcb 0 1 0 1
7ed4def5-d5bb-4818-8748-5bb5f8315fa2 0 1 0 1
5184d96a-ee8c-499a-9316-625496784de6 0 1 0 1
48265174-8451-4967-973a-639c2276cfaf 0 1 0 1
26a266f1-1d23-40e2-af48-6ab8d954fe37 0 1 0 1
7ee72c7e-9800-44c1-b82d-6e34e8289ca1 0 1 0 1
b706c1d6-fb99-40b5-844c-6ee54701ba0d 0 1 0 1
27cf33af-c338-4842-966c-75ca11aaa6a3 0 1 0 1
82f61d73-0bf5-44ff-ab99-dd73aee9b9cc 0 1 0 1
2a8bd319-36fb-4fba-9e07-e303839f1974 0 1 0 1
f4f544ae-381a-4323-9a59-f5a629e21f46 0 1 0 1
52f6be23-5363-4d93-96ae-f714b851e52c 0 1 0 1

Detailed Statistics General

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
AK_Document_DocumentLevel_DocumentNode Aug 8 2010 5:23PM 13 13 3 0 3.615385 false 13

Detailed Statistics Density

All Density Average Length Columns
0.3333333 2 DocumentLevel
0.07692308 3.615385 DocumentLevel, DocumentNode

Detailed Statistics Histogram

Range High Key Range Rows Estimated Rows Distinct Range Rows Avg Range Rows
0 0 1 0 1
1 0 3 0 1
2 0 9 0 1

Detailed Statistics General

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
_WA_Sys_00000002_2F10007B Aug 8 2010 5:23PM 13 13 3 0 2 false 13

Detailed Statistics Density

All Density Average Length Columns
0.3333333 2 DocumentLevel

Detailed Statistics Histogram

Range High Key Range Rows Estimated Rows Distinct Range Rows Avg Range Rows
0 0 1 0 1
1 0 3 0 1
2 0 9 0 1

Detailed Statistics General

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
AK_Document_rowguid Aug 8 2010 5:23PM 13 13 13 0 17.61539 false 13

Detailed Statistics Density

All Density Average Length Columns
0.07692308 16 rowguid
0.07692308 17.61539 rowguid, DocumentNode

Detailed Statistics Histogram

Range High Key Range Rows Estimated Rows Distinct Range Rows Avg Range Rows
d11b82b0-eb40-4a66-8193-15f765a61f05 0 1 0 1
79d41fe8-39d7-4591-9a05-285a3e1aafcb 0 1 0 1
7ed4def5-d5bb-4818-8748-5bb5f8315fa2 0 1 0 1
5184d96a-ee8c-499a-9316-625496784de6 0 1 0 1
48265174-8451-4967-973a-639c2276cfaf 0 1 0 1
26a266f1-1d23-40e2-af48-6ab8d954fe37 0 1 0 1
7ee72c7e-9800-44c1-b82d-6e34e8289ca1 0 1 0 1
b706c1d6-fb99-40b5-844c-6ee54701ba0d 0 1 0 1
27cf33af-c338-4842-966c-75ca11aaa6a3 0 1 0 1
82f61d73-0bf5-44ff-ab99-dd73aee9b9cc 0 1 0 1
2a8bd319-36fb-4fba-9e07-e303839f1974 0 1 0 1
f4f544ae-381a-4323-9a59-f5a629e21f46 0 1 0 1
52f6be23-5363-4d93-96ae-f714b851e52c 0 1 0 1

Detailed Statistics General

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
IX_Document_FileName_Revision Aug 8 2010 5:23PM 13 13 12 1 59.46154 true 13

Detailed Statistics Density

All Density Average Length Columns
0.07692308 47.84615 FileName
0.07692308 57.84615 FileName, Revision
0.07692308 59.46154 FileName, Revision, DocumentNode

Detailed Statistics Histogram

Range High Key Range Rows Estimated Rows Distinct Range Rows Avg Range Rows
Assembly 0 1 0 1
Crank Arm and Tire Maintenance.doc 0 1 0 1
Documents 0 1 0 1
Front Reflector Bracket and Reflector Assembly 3.doc 0 1 0 1
Front Reflector Bracket Installation.doc 0 1 0 1
Installing Replacement Pedals.doc 0 1 0 1
Introduction 1.doc 0 1 0 1
Lubrication Maintenance.doc 0 1 0 1
Maintenance 0 1 0 1
Overview 0 1 0 1
Repair and Service Guidelines.doc 0 1 0 1
Training Wheels 2.doc 1 1 1 1

Detailed Statistics General

NameUpdatedRowsRows SampledStepsDensityAverage Key LengthString IndexFilter ExpressionUnfiltered Rows
_WA_Sys_00000004_2F10007B Aug 8 2010 5:23PM 13 13 3 0 4 false 13

Detailed Statistics Density

All Density Average Length Columns
0.3333333 4 Owner

Detailed Statistics Histogram

Range High Key Range Rows Estimated Rows Distinct Range Rows Avg Range Rows
217 0 4 0 1
219 0 4 0 1
220 0 5 0 1

Objects that depend on [Document]

Objects on which [Document] depends

SQL

Script
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ARITHABORT ON
CREATE TABLE [Production].[Document]( [DocumentNode] [hierarchyid] NOT NULL, [DocumentLevel] AS ([DocumentNode].[GetLevel]()), [Title] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Owner] [int] NOT NULL, [FolderFlag] [bit] 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) FILESTREAM NULL, [rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY] FILESTREAM_ON [DocumentFileStreamGroup]
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key for Document records.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Document', @level2type=N'COLUMN',@level2name=N'DocumentNode'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Depth in the document hierarchy.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Document', @level2type=N'COLUMN',@level2name=N'DocumentLevel'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Title of the document.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Document', @level2type=N'COLUMN',@level2name=N'Title'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Employee who controls the document. Foreign key to Employee.BusinessEntityID' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Document', @level2type=N'COLUMN',@level2name=N'Owner'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0 = This is a folder, 1 = This is a document.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Document', @level2type=N'COLUMN',@level2name=N'FolderFlag'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'File name of the document' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Document', @level2type=N'COLUMN',@level2name=N'FileName'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'File extension indicating the document type. For example, .doc or .txt.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Document', @level2type=N'COLUMN',@level2name=N'FileExtension'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Revision number of the document. ' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Document', @level2type=N'COLUMN',@level2name=N'Revision'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Engineering change approval number.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Document', @level2type=N'COLUMN',@level2name=N'ChangeNumber'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1 = Pending approval, 2 = Approved, 3 = Obsolete' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Document', @level2type=N'COLUMN',@level2name=N'Status'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Document abstract.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Document', @level2type=N'COLUMN',@level2name=N'DocumentSummary'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Complete document.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Document', @level2type=N'COLUMN',@level2name=N'Document'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ROWGUIDCOL number uniquely identifying the record. Required for FileStream.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Document', @level2type=N'COLUMN',@level2name=N'rowguid'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time the record was last updated.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Document', @level2type=N'COLUMN',@level2name=N'ModifiedDate'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Product maintenance documents.' , @level0type=N'SCHEMA',@level0name=N'Production', @level1type=N'TABLE',@level1name=N'Document'

See also

List of Tables