Table d47civi_0z3xa.civicrm_country Generated by
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
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 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 at mer. avr. 13 16:52 EDT 2016

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

Close relationships  within of separation: