| id |
INT UNSIGNED |
10 |
|
√ |
null |
|
|
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 |
|
|
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 |
|
|
Foreign key to civicrm_worldregion.id. |
| is_province_abbreviated |
TINYINT |
3 |
√ |
|
0 |
|
|
Should state/province be displayed as abbreviation for contacts from this country? |
