Person_Temporal

--

Package Physical datamodel example
Author Bert Dingemans
Alias --
Stereotypes table

Attributes

Name Type Cardinality Description
BusinessEntityID int 1 - 1--
PersonType nchar 1 - 1--
NameStyle bit 1 - 1--
Title nvarchar 1 - 1--
FirstName nvarchar 1 - 1--
MiddleName nvarchar 1 - 1--
LastName nvarchar 1 - 1--
Suffix nvarchar 1 - 1--
EmailPromotion int 1 - 1--
ValidFrom datetime2 1 - 1--
ValidTo datetime2 1 - 1--

Diagrams