Element

Title

BusinessEntityAddress

Package Name

Physical datamodel example

Description

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

Attributes

NameTypeMincardMaxcardDescription
BusinessEntityIDint11Primary key. Foreign key to BusinessEntity.BusinessEntityID.
AddressIDint11Primary key. Foreign key to Address.AddressID.
AddressTypeIDint11Primary key. Foreign key to AddressType.AddressTypeID.
rowguiduniqueidentifier11ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDatedatetime11Date and time the record was last updated.


Display in diagrams

Linked elements