Application.StateProvinces

Generated using SQL Data Dictionary demo version.

Table Application.StateProvinces (53 rows)

States or provinces that contain cities (including geographic location)

	Column	Data Type	Identity	Nullable	Default
PK	StateProvinceID	int			NEXT VALUE FOR [Sequences].[StateProvinceID]
Numeric ID used for reference to a state or province within the database
	StateProvinceCode	nvarchar(5)
Common code for this state or province (such as WA - Washington for the USA)
UK	StateProvinceName	nvarchar(50)
Formal name of the state or province
FK	CountryID	int
Country for this StateProvince
	SalesTerritory	nvarchar(50)
Sales territory for this StateProvince
	Border	geography		X
Geographic boundary of the state or province
	LatestRecordedPopulation	bigint		X
Latest available population for the StateProvince
FK	LastEditedBy	int
	ValidFrom	datetime2
	ValidTo	datetime2

Indexes:

PK_Application_StateProvinces
- (Primary Key)
- (Clustered)
- (1.89% Selectivity)
- StateProvinceID

UQ_Application_StateProvinces_StateProvinceName
- (Unique)
- (1.89% Selectivity)
- StateProvinceName

FK_Application_StateProvinces_CountryID
- (100% Selectivity)
Auto-created to support a foreign key
- CountryID

IX_Application_StateProvinces_SalesTerritory
- (11.11% Selectivity)
Index used to quickly locate sales territories
- SalesTerritory

References:

Application.Countries
- CountryID

Application.People
- PersonID (LastEditedBy)

Referenced by:

Application.Cities
- StateProvinceID

Used by:

Function
Application.DetermineCustomerAccess
- SalesTerritory
- StateProvinceID
Procedure
Integration.GetCityUpdates
- StateProvinceID
- ValidFrom