Person.StateProvince (table)

wikibot

Table

Person.StateProvince

Column	Data Type	Nullable	Default	PK	Index
StateProvinceID	int	not null		PK_StateProvince_StateProvinceID
StateProvinceCode	nchar(3)	not null			AK_StateProvince_StateProvinceCode_CountryRegionCode
CountryRegionCode	nvarchar(3)	not null			AK_StateProvince_StateProvinceCode_CountryRegionCode
IsOnlyStateProvinceFlag	dbo.Flag	not null	((1))
Name	dbo.Name	not null			AK_StateProvince_Name
TerritoryID	int	not null
rowguid	uniqueidentifier	not null	(newid())		AK_StateProvince_rowguid
ModifiedDate	datetime	not null	(getdate())

Relation	Column	Referenced Column
Person.CountryRegion	CountryRegionCode	CountryRegionCode
Sales.SalesTerritory	TerritoryID	TerritoryID

Detail Table	Column	Referencing Column
Person.Address	StateProvinceID	StateProvinceID
Sales.SalesTaxRate	StateProvinceID	StateProvinceID