Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
civicrm_address.state_province_id FK_civicrm_address_state_province_id N
civicrm_county.state_province_id FK_civicrm_county_state_province_id R

State/Province ID

name VARCHAR 64 null

Name of State/Province

abbreviation VARCHAR 4 null

2-4 Character Abbreviation of State/Province

country_id INT UNSIGNED 10 null FK_civicrm_state_province_country_id R

ID of Country that State/Province belong

Table contained 3934 rows


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_state_province_country_id Performance Asc country_id
UI_name_country_id Must be unique Asc/Asc name + country_id