meta_countries
ISO country codes with regional and currency data.
| Name | Type | Nullable | Default Value | Notes |
|---|---|---|---|---|
ID | smallint | |||
subregion meta_subregions.ID | smallint | |||
currency meta_currencies.ID | smallint | |||
tld meta_tlds.ID | smallint | |||
iso_alpha2 | character varying(2) | |||
iso_alpha3 | character varying(3) | |||
iso_numeric | character varying(3) | |||
edgar | character varying(2) | |||
fifa | character varying(4) | |||
fips | character varying(4) | |||
ioc | character varying(3) | |||
itu | character varying(3) | |||
m49 | character varying(3) | |||
marc | text | |||
vri | character varying(3) | |||
wmo | character varying(2) | |||
geonameid | integer | |||
wikidataid | text | |||
independent | boolean | |||
un | boolean | |||
ldc | boolean | |||
lldc | boolean | |||
sids | boolean | |||
flag | text | |||
latitude | double precision | |||
longitude | double precision | |||
population | bigint | |||
area | integer | |||
capital | text | |||
callingcodes | text[] |
| Name | Unique | Nulls Distinct | Primary | Partial | Method | Keys |
|---|---|---|---|---|---|---|
| fk_meta_countries_subregion | gin | subregion | ||||
| pk_meta_countries | btree | ID | ||||
| u_meta_countries_iso_alpha2 | btree | iso_alpha2 | ||||
| u_meta_countries_iso_alpha3 | btree | iso_alpha3 | ||||
| u_meta_countries_iso_numeric | btree | iso_numeric |
| Name | Type |
|---|---|
| fk_meta_countries_currency | foreign_key |
| fk_meta_countries_subregion | foreign_key |
| fk_meta_countries_tld | foreign_key |
| pk_meta_countries | primary_key |
| u_meta_countries_iso_alpha2 | unique |
| u_meta_countries_iso_alpha3 | unique |
Loading...