civicrm_state_province - civicrm Database

Search:

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

FK_civicrm_state_province_country_idR

ID of Country that State/Province belong

Showing 1 to 4 of 4 entries

Search:

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

Showing 1 to 3 of 3 entries