Production.Document

Columns

• //

  ${escapify(column.description)}
  DocumentNode
  [hierarchyid] NOT NULL
• //

  ${escapify(column.description)}
  DocumentLevel
  [smallint] NULL
• //

  ${escapify(column.description)}
  Title
  [nvarchar](50) NOT NULL
• //

  ${escapify(column.description)}
  Owner
  [int] NOT NULL
• //

  ${escapify(column.description)}
  FolderFlag
  [bit] NOT NULL DEFAULT ((0))
• //

  ${escapify(column.description)}
  FileName
  [nvarchar](400) NOT NULL
• //

  ${escapify(column.description)}
  FileExtension
  [nvarchar](8) NOT NULL
• //

  ${escapify(column.description)}
  Revision
  [nchar](5) NOT NULL
• //

  ${escapify(column.description)}
  ChangeNumber
  [int] NOT NULL DEFAULT ((0))
• //

  ${escapify(column.description)}
  Status
  [tinyint] NOT NULL

  //

  CONSTRAINT: Check constraint [Status] BETWEEN (1) AND (3)

  ([Status]>=(1) AND [Status]<=(3))
• //

  ${escapify(column.description)}
  DocumentSummary
  [nvarchar](MAX) NULL
• //

  ${escapify(column.description)}
  Document
  [varbinary](MAX) NULL
• //

  ${escapify(column.description)}
  rowguid
  [uniqueidentifier] NOT NULL DEFAULT (newid())
• //

  ${escapify(column.description)}
  ModifiedDate
  [datetime] NOT NULL DEFAULT (getdate())

Indexes

• //

  Clustered index created by a primary key constraint.
  PK_Document_DocumentNode
  UNIQUE CLUSTERED
  DocumentNode
• UQ__Document__F73921F7C81C642F
  UNIQUE NONCLUSTERED
  rowguid
• //

  Unique nonclustered index.
  AK_Document_DocumentLevel_DocumentNode
  UNIQUE NONCLUSTERED
  DocumentLevel , DocumentNode
• //

  Unique nonclustered index. Used to support FileStream.
  AK_Document_rowguid
  UNIQUE NONCLUSTERED
  rowguid
• //

  Unique nonclustered index.
  IX_Document_FileName_Revision
  NONCLUSTERED
  FileName , Revision

Foreign Keys

• //

  Foreign key constraint referencing Employee.BusinessEntityID.
  FK_Document_Employee_Owner
  HumanResources.Employee
  Owner ⥱ BusinessEntityID

Sample Data