Person_json

--

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

Attributes

Name	Type	Cardinality	Description
PersonID	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	--
AdditionalContactInfo	nvarchar(max)	1 - 1	--
Demographics	nvarchar(max)	1 - 1	--
rowguid	uniqueidentifier	1 - 1	--
ModifiedDate	datetime	1 - 1	--

Diagrams

Import Adventureworks Database

--

---