Table d44civi_9xzwf.civicrm_country Generated by
SchemaSpy
Legend: SourceForge.net
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
civicrm_address_format.id FK_civicrm_country_address_format_id R
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
civicrm_worldregion.id FK_civicrm_country_region_id R
Foreign key to civicrm_worldregion.id.
is_province_abbreviated tinyint 3  √  0 Should state/province be displayed as abbreviation for contacts from this country?

Table contained 249 rows at Wed Nov 11 17:14 EST 2015

Indexes:
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: