Element

Title

BusinessEntity

Package Name

Physical datamodel example

Description

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

Attributes

NameTypeMincardMaxcardDescription
BusinessEntityIDint11Primary key for all customers, vendors, and employees.
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