StateProvince

State and province lookup table.

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

Attributes

Name	Type	Cardinality	Description
StateProvinceID	int	1 - 1	Primary key for StateProvince records.
StateProvinceCode	nchar	1 - 1	ISO standard state or province code.
CountryRegionCode	nvarchar	1 - 1	ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode.
IsOnlyStateProvinceFlag	bit	1 - 1	0 = StateProvinceCode exists. 1 = StateProvinceCode unavailable, using CountryRegionCode.
Name	nvarchar	1 - 1	State or province description.
TerritoryID	int	1 - 1	ID of the territory in which the state or province is located. Foreign key to SalesTerritory.SalesTerritoryID.
rowguid	uniqueidentifier	1 - 1	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime	1 - 1	Date and time the record was last updated.

Diagrams

Import Adventureworks Database

--

Linked elements

Physical datamodel example

• Address FK
• CountryRegion FK

---

---