civicrm_state_province

3945 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
civicrm_address.state_province_id FK_civicrm_address_state_province_idN
civicrm_county.state_province_id FK_civicrm_county_state_province_idR

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
civicrm_country.id FK_civicrm_state_province_country_idR

ID of Country that State/Province belong

Indexes

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

Relationships

Close relationships within degrees of separation