Person.Person

Columns

• //

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

  ${escapify(column.description)}
  PersonType
  [nchar](2) NOT NULL

  //

  CONSTRAINT: Check constraint [PersonType] is one of SC, VC, IN, EM or SP.

  ([PersonType] IS NULL OR (upper([PersonType])='GC' OR upper([PersonType])='SP' OR upper([PersonType])='EM' OR upper([PersonType])='IN' OR upper([PersonType])='VC' OR upper([PersonType])='SC'))
• //

  ${escapify(column.description)}
  NameStyle
  [NameStyle] NOT NULL DEFAULT ((0))

  //

  USER-DEFINED DATA TYPE

  [bit] NOT NULL
• //

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

  ${escapify(column.description)}
  FirstName
  [Name] NOT NULL

  //

  USER-DEFINED DATA TYPE

  [nvarchar](50) NULL
• //

  ${escapify(column.description)}
  MiddleName
  [Name] NULL

  //

  USER-DEFINED DATA TYPE

  [nvarchar](50) NULL
• //

  ${escapify(column.description)}
  LastName
  [Name] NOT NULL

  //

  USER-DEFINED DATA TYPE

  [nvarchar](50) NULL
• //

  ${escapify(column.description)}
  Suffix
  [nvarchar](10) NULL
• //

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

  //

  CONSTRAINT: Check constraint [EmailPromotion] >= (0) AND [EmailPromotion] <= (2)

  ([EmailPromotion]>=(0) AND [EmailPromotion]<=(2))
• //

  ${escapify(column.description)}
  AdditionalContactInfo
  [xml] NULL
• //

  ${escapify(column.description)}
  Demographics
  [xml] 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_Person_BusinessEntityID
  UNIQUE CLUSTERED
  BusinessEntityID
• IX_Person_LastName_FirstName_MiddleName
  NONCLUSTERED
  LastName , FirstName , MiddleName
• //

  Unique nonclustered index. Used to support replication samples.
  AK_Person_rowguid
  UNIQUE NONCLUSTERED
  rowguid
• //

  Primary XML index.
  PXML_Person_AddContact
  XML
  AdditionalContactInfo
• //

  Primary XML index.
  PXML_Person_Demographics
  XML
  Demographics
• //

  Secondary XML index for path.
  XMLPATH_Person_Demographics
  XML
  Demographics
• //

  Secondary XML index for property.
  XMLPROPERTY_Person_Demographics
  XML
  Demographics
• //

  Secondary XML index for value.
  XMLVALUE_Person_Demographics
  XML
  Demographics

Foreign Keys

• //

  Foreign key constraint referencing BusinessEntity.BusinessEntityID.
  FK_Person_BusinessEntity_BusinessEntityID
  Person.BusinessEntity
  BusinessEntityID ⥱ BusinessEntityID

Sample Data