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

Import Adventureworks Database

--

---