# 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 |
Quoted Identifier |
Lock Escalation | TABLE
Lock On Bulk Load |
Lob Data Space | PRIMARY
Filestream Data Space ID | 2
Has Unchecked Assembly Data |
Text In Row Limit (bytes) | Option not set
Large Value Types Out Of Row |
FullText Change Tracking On |
Tracked By Cdc |
Published |
Schema Published |
Replicated |
Replication Filter |
Merge Published |
Sync Tran Subscribed |
MS Shipped |
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 |  |  |
2 | DocumentLevel | smallint |  |  |
3 | Title | nvarchar(50) |  |  |
4 | Owner | int |  |  |
5 | FolderFlag | bit |  |  |
6 | FileName | nvarchar(400) |  |  |
7 | FileExtension | nvarchar(8) |  |  |
8 | Revision | nchar(5) |  |  |
9 | ChangeNumber | int |  |  |
10 | Status | tinyint |  |  |
11 | DocumentSummary | nvarchar(max) |  |  |
12 | Document | varbinary(max) |  |  |
13 | rowguid | uniqueidentifier |  |  |
14 | ModifiedDate | datetime |  |  |

## Identity Columns

No identity columns defined.

## Primary Key Constraints

Name | Is System Named | Extended Property Name | Extended Property Value
--- | --- | --- | ---
PK_Document_DocumentNode |  | 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)) |  |  |  |  |

## 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)) |  |  |
DF_Document_ChangeNumber | ChangeNumber | ((0)) |  | MS_Description | Default constraint value of 0
DF_Document_rowguid | rowguid | (newid()) |  | MS_Description | Default constraint value of NEWID()
DF_Document_ModifiedDate | ModifiedDate | (getdate()) |  | MS_Description | Default constraint value of GETDATE()

## Indexes

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

## FullText Indexes

Name | Corresponding Unique Index Name | Is Enabled | Change Tracking State Description
--- | --- | --- | ---
FullText Index | PK_Document_DocumentNode |  | 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 |  |  |  | No action | No action |  | 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

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
PK_Document_DocumentNode | Aug 8 2010 5:22PM | 13 | 13 | 7 | 1 | 1.615385 |  |  | 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

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
UQ__Document__F73921F730F848ED | Aug 8 2010 5:22PM | 13 | 13 | 13 | 0 | 17.61539 |  |  | 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

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
AK_Document_DocumentLevel_DocumentNode | Aug 8 2010 5:23PM | 13 | 13 | 3 | 0 | 3.615385 |  |  | 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

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
_WA_Sys_00000002_2F10007B | Aug 8 2010 5:23PM | 13 | 13 | 3 | 0 | 2 |  |  | 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

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
AK_Document_rowguid | Aug 8 2010 5:23PM | 13 | 13 | 13 | 0 | 17.61539 |  |  | 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

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
IX_Document_FileName_Revision | Aug 8 2010 5:23PM | 13 | 13 | 12 | 1 | 59.46154 |  |  | 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

Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
_WA_Sys_00000004_2F10007B | Aug 8 2010 5:23PM | 13 | 13 | 3 | 0 | 4 |  |  | 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]

- Production.Document
  - Production.ProductDocument

## Objects on which [Document] depends

- Production.Document
  - HumanResources.Employee
    - Person.Person
      - Person.AdditionalContactInfoSchemaCollection
      - Person.BusinessEntity
      - Demographics.exist
      - Person.IndividualSurveySchemaCollection
      - dbo.Name
      - dbo.NameStyle
    - dbo.Flag

## 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