Element

Title

StateProvince

Package Name

Physical datamodel example

Description

State and province lookup table.

Attributes

NameTypeMincardMaxcardDescription
StateProvinceIDint11Primary key for StateProvince records.
StateProvinceCodenchar11ISO standard state or province code.
CountryRegionCodenvarchar11ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode.
IsOnlyStateProvinceFlagbit110 = StateProvinceCode exists. 1 = StateProvinceCode unavailable, using CountryRegionCode.
Namenvarchar11State or province description.
TerritoryIDint11ID of the territory in which the state or province is located. Foreign key to SalesTerritory.SalesTerritoryID.
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

Physical datamodel example