Person.BusinessEntityAddress - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Person
Name	BusinessEntityAddress
Module	People

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

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		BusinessEntityID	int			Person.BusinessEntity	Primary key. Foreign key to BusinessEntity.BusinessEntityID.
Primary key. Foreign key to BusinessEntity.BusinessEntityID. References: Person.BusinessEntity
	2		AddressID	int			Person.Address	Primary key. Foreign key to Address.AddressID.
Primary key. Foreign key to Address.AddressID. References: Person.Address
	3		AddressTypeID	int			Person.AddressType	Primary key. Foreign key to AddressType.AddressTypeID.
Primary key. Foreign key to AddressType.AddressTypeID. References: Person.AddressType
	4		rowguid	uniqueidentifier		Default: newid()		ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. Default: newid()
	5		ModifiedDate	datetime		Default: getdate()		Date and time the record was last updated.
Date and time the record was last updated. Default: getdate()

Relations

Foreign table		Primary table	Join	Title / Name / Description
Person.BusinessEntityAddress		Person.Address	Person.BusinessEntityAddress.AddressID = Person.Address.AddressID	FK_BusinessEntityAddress_Address_AddressID Foreign key constraint referencing Address.AddressID.
Person.BusinessEntityAddress.AddressID = Person.Address.AddressID Name: FK_BusinessEntityAddress_Address_AddressID Foreign key constraint referencing Address.AddressID.
Person.BusinessEntityAddress		Person.AddressType	Person.BusinessEntityAddress.AddressTypeID = Person.AddressType.AddressTypeID	FK_BusinessEntityAddress_AddressType_AddressTypeID Foreign key constraint referencing AddressType.AddressTypeID.
Person.BusinessEntityAddress.AddressTypeID = Person.AddressType.AddressTypeID Name: FK_BusinessEntityAddress_AddressType_AddressTypeID Foreign key constraint referencing AddressType.AddressTypeID.
Person.BusinessEntityAddress		Person.BusinessEntity	Person.BusinessEntityAddress.BusinessEntityID = Person.BusinessEntity.BusinessEntityID	FK_BusinessEntityAddress_BusinessEntity_BusinessEntityID Foreign key constraint referencing BusinessEntity.BusinessEntityID.
Person.BusinessEntityAddress.BusinessEntityID = Person.BusinessEntity.BusinessEntityID Name: FK_BusinessEntityAddress_BusinessEntity_BusinessEntityID Foreign key constraint referencing BusinessEntity.BusinessEntityID.

Unique keys

	Key name	Columns	Description
	PK_BusinessEntityAddress_BusinessEntityID_AddressID_AddressTypeID	BusinessEntityID, AddressID, AddressTypeID	Primary key (clustered) constraint
Primary key (clustered) constraint
	AK_BusinessEntityAddress_rowguid	rowguid	Unique nonclustered index. Used to support replication samples.
Unique nonclustered index. Used to support replication samples.

Uses

Name
Person.BusinessEntityAddress
Person.Address
Person.AddressType
Person.BusinessEntity

Used by

Name
Person.BusinessEntityAddress
HumanResources.vEmployee
Purchasing.vVendorWithAddresses
Sales.vIndividualCustomer
Sales.vSalesPerson
Sales.vStoreWithAddresses

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56