Application.StateProvinces - WideWorldImporters

States or provinces that contain cities (including geographic location)

Cities are part of states or provinces. This table has details of those, including spatial data describing the boundaries each state or province.

Columns

		Name	Data type	Attributes	References	Description
	1	StateProvinceID	int	Default: NEXT VALUE FOR [Sequences].[StateProvinceID]		Numeric ID used for reference to a state or province within the database
Numeric ID used for reference to a state or province within the database Default: NEXT VALUE FOR [Sequences].[StateProvinceID]
	2	StateProvinceCode	nvarchar(5)			Common code for this state or province (such as WA - Washington for the USA)
Common code for this state or province (such as WA - Washington for the USA)
	3	StateProvinceName	nvarchar(50)			Formal name of the state or province
Formal name of the state or province
	4	CountryID	int		Application.Countries	Country for this StateProvince
Country for this StateProvince References: Application.Countries
	5	SalesTerritory	nvarchar(50)			Sales territory for this StateProvince
Sales territory for this StateProvince
	6	Border	geography			Geographic boundary of the state or province
Geographic boundary of the state or province
	7	LatestRecordedPopulation	bigint			Latest available population for the StateProvince
Latest available population for the StateProvince
	8	LastEditedBy	int		Application.People
References: Application.People
	9	ValidFrom	datetime2(7)			Valid from this date and time
Valid from this date and time
	10	ValidTo	datetime2(7)			Valid until this date and time
Valid until this date and time

Relations

Foreign table	Primary table	Join	Title / Name / Description
Application.StateProvinces	Application.Countries	Application.StateProvinces.CountryID = Application.Countries.CountryID	FK_Application_StateProvinces_CountryID_Application_Countries Foreign key constraint referencing Countries.CountryID
Application.StateProvinces.CountryID = Application.Countries.CountryID Name: FK_Application_StateProvinces_CountryID_Application_Countries Foreign key constraint referencing Countries.CountryID
Application.StateProvinces	Application.People	Application.StateProvinces.LastEditedBy = Application.People.PersonID	FK_Application_StateProvinces_Application_People Foreign key constraint referencing People.PersonID
Application.StateProvinces.LastEditedBy = Application.People.PersonID Name: FK_Application_StateProvinces_Application_People Foreign key constraint referencing People.PersonID
Application.Cities	Application.StateProvinces	Application.Cities.StateProvinceID = Application.StateProvinces.StateProvinceID	FK_Application_Cities_StateProvinceID_Application_StateProvinces Foreign key constraint referencing StateProvinces.StateProvinceID
Application.Cities.StateProvinceID = Application.StateProvinces.StateProvinceID Name: FK_Application_Cities_StateProvinceID_Application_StateProvinces Foreign key constraint referencing StateProvinces.StateProvinceID

Unique keys

	Key name	Columns	Description
	PK_Application_StateProvinces	StateProvinceID	Primary key (clustered) constraint.
Primary key (clustered) constraint.
	UQ_Application_StateProvinces_StateProvinceName	StateProvinceName	Unique nonclustered index.
Unique nonclustered index.

Uses

Name
Application.StateProvinces
Application.Countries
Application.People

Used by

Name
Application.StateProvinces
Application.Cities

Exported: 2019-02-04 23:04, Last imported: 2018-08-10 09:51