Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null
civicrm_address.country_id FK_civicrm_address_country_id N
civicrm_state_province.country_id FK_civicrm_state_province_country_id R
civicrm_timezone.country_id FK_civicrm_timezone_country_id R

Country Id

name VARCHAR 64 null

Country Name

iso_code CHAR 2 null

ISO Code

country_code VARCHAR 4 null

National prefix to be used when dialing TO this country.

address_format_id INT UNSIGNED 10 null FK_civicrm_country_address_format_id R

Foreign key to

idd_prefix VARCHAR 4 null

International direct dialing prefix from within the country TO another country

ndd_prefix VARCHAR 4 null

Access prefix to call within a country to a different area

region_id INT UNSIGNED 10 null FK_civicrm_country_region_id R

Foreign key to

is_province_abbreviated TINYINT 3 0

Should state/province be displayed as abbreviation for contacts from this country?

Table contained 251 rows


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_country_address_format_id Performance Asc address_format_id
FK_civicrm_country_region_id Performance Asc region_id
UI_name_iso_code Must be unique Asc/Asc name + iso_code