Person StateProvince (table)

wikibot

TablePerson.StateProvince
DescriptionState and province lookup table.

Columns

ColumnData TypeNullableDefaultDescription
StateProvinceIDintnot null Primary key for StateProvince records.
StateProvinceCodenchar(3)not null ISO standard state or province code.
CountryRegionCodenvarchar(3)not null ISO standard country or region code. Foreign key to CountryRegion.CountryRegionCode.
IsOnlyStateProvinceFlagdbo.Flagnot null((1))0 = StateProvinceCode exists. 1 = StateProvinceCode unavailable, using CountryRegionCode.
Namedbo.Namenot null State or province description.
TerritoryIDintnot null ID of the territory in which the state or province is located. Foreign key to SalesTerritory.SalesTerritoryID.
rowguiduniqueidentifiernot null(newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Primary Key

Primary KeyColumns
PK_StateProvince_StateProvinceIDStateProvinceID

Indexes

IndexTypeColumns
AK_StateProvince_NameUniqueName
AK_StateProvince_rowguidUniquerowguid
AK_StateProvince_StateProvinceCode_CountryRegionCodeUniqueStateProvinceCode, CountryRegionCode

Foreign Keys

RelationColumnReferenced Column
Person.CountryRegionCountryRegionCodeCountryRegionCode
Sales.SalesTerritoryTerritoryIDTerritoryID

Detail Tables

Detail TableColumnReferencing Column
Person.AddressStateProvinceIDStateProvinceID
Sales.SalesTaxRateStateProvinceIDStateProvinceID

References

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Flag
Data TypeTypedbo.Name
SchemaSchemaPerson

Dependencies

Reference TypeObject TypeReferencing Object
SelectViewHumanResources.vEmployee
SelectViewPerson.vStateProvinceCountryRegion
SelectViewPurchasing.vVendor
SelectViewSales.vIndividualCustomer
SelectViewSales.vSalesPerson
SelectViewSales.vStoreWithDemographics