Person.BusinessEntityAddress

Columns

• //

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

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

  ${escapify(column.description)}
  AddressTypeID
  [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_BusinessEntityAddress_BusinessEntityID_AddressID_AddressTypeID
  UNIQUE CLUSTERED
  BusinessEntityID , AddressID , AddressTypeID
• //

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

  Nonclustered index.
  IX_BusinessEntityAddress_AddressID
  NONCLUSTERED
  AddressID
• //

  Nonclustered index.
  IX_BusinessEntityAddress_AddressTypeID
  NONCLUSTERED
  AddressTypeID

Foreign Keys

• //

  Foreign key constraint referencing Address.AddressID.
  FK_BusinessEntityAddress_Address_AddressID
  Person.Address
  AddressID ⥱ AddressID
• //

  Foreign key constraint referencing AddressType.AddressTypeID.
  FK_BusinessEntityAddress_AddressType_AddressTypeID
  Person.AddressType
  AddressTypeID ⥱ AddressTypeID
• //

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

Sample Data