Person.BusinessEntityContact

Columns

• //

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

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

  ${escapify(column.description)}
  ContactTypeID
  [int] NOT 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_BusinessEntityContact_BusinessEntityID_PersonID_ContactTypeID
  UNIQUE CLUSTERED
  BusinessEntityID , PersonID , ContactTypeID
• //

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

  Nonclustered index.
  IX_BusinessEntityContact_PersonID
  NONCLUSTERED
  PersonID
• //

  Nonclustered index.
  IX_BusinessEntityContact_ContactTypeID
  NONCLUSTERED
  ContactTypeID

Foreign Keys

• //

  Foreign key constraint referencing BusinessEntity.BusinessEntityID.
  FK_BusinessEntityContact_BusinessEntity_BusinessEntityID
  Person.BusinessEntity
  BusinessEntityID ⥱ BusinessEntityID
• //

  Foreign key constraint referencing ContactType.ContactTypeID.
  FK_BusinessEntityContact_ContactType_ContactTypeID
  Person.ContactType
  ContactTypeID ⥱ ContactTypeID
• //

  Foreign key constraint referencing Person.BusinessEntityID.
  FK_BusinessEntityContact_Person_PersonID
  Person.Person
  PersonID ⥱ BusinessEntityID

Sample Data