Person.BusinessEntity - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Person
Name	BusinessEntity
Module	People

Source of the ID that connects vendors, customers, and employees with address and contact information.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		BusinessEntityID	int		Identity		Primary key for all customers, vendors, and employees.
Primary key for all customers, vendors, and employees. Identity
	2		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()
	3		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.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.
Person.BusinessEntityContact		Person.BusinessEntity	Person.BusinessEntityContact.BusinessEntityID = Person.BusinessEntity.BusinessEntityID	FK_BusinessEntityContact_BusinessEntity_BusinessEntityID Foreign key constraint referencing BusinessEntity.BusinessEntityID.
Person.BusinessEntityContact.BusinessEntityID = Person.BusinessEntity.BusinessEntityID Name: FK_BusinessEntityContact_BusinessEntity_BusinessEntityID Foreign key constraint referencing BusinessEntity.BusinessEntityID.
Person.Person		Person.BusinessEntity	Person.Person.BusinessEntityID = Person.BusinessEntity.BusinessEntityID	FK_Person_BusinessEntity_BusinessEntityID Foreign key constraint referencing BusinessEntity.BusinessEntityID.
Person.Person.BusinessEntityID = Person.BusinessEntity.BusinessEntityID Name: FK_Person_BusinessEntity_BusinessEntityID Foreign key constraint referencing BusinessEntity.BusinessEntityID.
Sales.Store		Person.BusinessEntity	Sales.Store.BusinessEntityID = Person.BusinessEntity.BusinessEntityID	FK_Store_BusinessEntity_BusinessEntityID Foreign key constraint referencing BusinessEntity.BusinessEntityID
Sales.Store.BusinessEntityID = Person.BusinessEntity.BusinessEntityID Name: FK_Store_BusinessEntity_BusinessEntityID Foreign key constraint referencing BusinessEntity.BusinessEntityID
Purchasing.Vendor		Person.BusinessEntity	Purchasing.Vendor.BusinessEntityID = Person.BusinessEntity.BusinessEntityID	FK_Vendor_BusinessEntity_BusinessEntityID Foreign key constraint referencing BusinessEntity.BusinessEntityID
Purchasing.Vendor.BusinessEntityID = Person.BusinessEntity.BusinessEntityID Name: FK_Vendor_BusinessEntity_BusinessEntityID Foreign key constraint referencing BusinessEntity.BusinessEntityID

Unique keys

	Key name	Columns	Description
	PK_BusinessEntity_BusinessEntityID	BusinessEntityID	Primary key (clustered) constraint
Primary key (clustered) constraint
	AK_BusinessEntity_rowguid	rowguid	Unique nonclustered index. Used to support replication samples.
Unique nonclustered index. Used to support replication samples.

Used by

Name
Person.BusinessEntity
Person.BusinessEntityAddress
Person.BusinessEntityContact
Person.Person
Purchasing.Vendor
Sales.Store

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