meta_countries
| Name | Type | Storage | Nullable | Foreign Keys | Default Value & Notes |
|---|---|---|---|---|---|
| ID | smallint | plain | No description provided. | ||
| subregion | smallint | plain | meta_subregions.ID | No description provided. | |
| currency | smallint | plain | meta_currencies.ID | No description provided. | |
| tld | smallint | plain | meta_tlds.ID | No description provided. | |
| iso_alpha2 | character varying(2) | extended | No description provided. | ||
| iso_alpha3 | character varying(3) | extended | No description provided. | ||
| iso_numeric | character varying(3) | extended | No description provided. | ||
| edgar | character varying(2) | extended | No description provided. | ||
| fifa | character varying(4) | extended | No description provided. | ||
| fips | character varying(4) | extended | No description provided. | ||
| ioc | character varying(3) | extended | No description provided. | ||
| itu | character varying(3) | extended | No description provided. | ||
| m49 | character varying(3) | extended | No description provided. | ||
| marc | text | extended | No description provided. | ||
| vri | character varying(3) | extended | No description provided. | ||
| wmo | character varying(2) | extended | No description provided. | ||
| geonameid | integer | plain | No description provided. | ||
| wikidataid | text | extended | No description provided. | ||
| independent | boolean | plain | No description provided. | ||
| un | boolean | plain | No description provided. | ||
| ldc | boolean | plain | No description provided. | ||
| lldc | boolean | plain | No description provided. | ||
| sids | boolean | plain | No description provided. | ||
| flag | text | extended | No description provided. | ||
| latitude | double precision | plain | No description provided. | ||
| longitude | double precision | plain | No description provided. | ||
| population | bigint | plain | No description provided. | ||
| area | integer | plain | No description provided. | ||
| capital | text | extended | No description provided. | ||
| callingcodes | text[] | extended | No description provided. |
| 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...