Person.BusinessEntityAddress

Generated using SQL Data Dictionary demo version.

Table Person.BusinessEntityAddress (19,614 rows)

Cross-reference table mapping customers, vendors, and employees to their addresses.

	Column	Data Type	Identity	Nullable	Default
PK, FK	BusinessEntityID	int
Primary key. Foreign key to BusinessEntity.BusinessEntityID.
PK, FK	AddressID	int
Primary key. Foreign key to Address.AddressID.
PK, FK	AddressTypeID	int
Primary key. Foreign key to AddressType.AddressTypeID.
UK	rowguid	uniqueidentifier			newid()
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
	ModifiedDate	datetime			getdate()
Date and time the record was last updated.

Indexes:

PK_BusinessEntityAddress_BusinessEntityID_AddressID_AddressTypeID
- (Primary Key)
- (Clustered)
Primary key (clustered) constraint
- BusinessEntityID
- AddressID
- AddressTypeID

AK_BusinessEntityAddress_rowguid
- (Unique)
Unique nonclustered index. Used to support replication samples.
- rowguid

IX_BusinessEntityAddress_AddressID
Nonclustered index.
- AddressID

IX_BusinessEntityAddress_AddressTypeID
Nonclustered index.
- AddressTypeID

References:

Person.Address
- AddressID

Person.AddressType
- AddressTypeID

Person.BusinessEntity
- BusinessEntityID

Used by:

View
HumanResources.vEmployee
- AddressID
- BusinessEntityID
View
Purchasing.vVendorWithAddresses
- AddressID
- AddressTypeID
- BusinessEntityID
View
Sales.vIndividualCustomer
- AddressID
- AddressTypeID
- BusinessEntityID
View
Sales.vSalesPerson
- AddressID
- BusinessEntityID
View
Sales.vStoreWithAddresses
- AddressID
- AddressTypeID
- BusinessEntityID