civicrm_country

251 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
civicrm_address.country_id FK_civicrm_address_country_idN
civicrm_state_province.country_id FK_civicrm_state_province_country_idR
civicrm_timezone.country_id FK_civicrm_timezone_country_idR

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
civicrm_address_format.id FK_civicrm_country_address_format_idR

Foreign key to civicrm_address_format.id.
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
civicrm_worldregion.id FK_civicrm_country_region_idR

Foreign key to civicrm_worldregion.id.
is_province_abbreviated TINYINT 3 √ 0

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

Indexes

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

Relationships

Close relationships within degrees of separation