Skip to main content

country

Country and continent mapping.

Primary key: country_id. See the version history of this table on dbdocs.io.

Columns​

ColumnTypeConstraintsReferencesDescription
country_idVARCHAR(255)PKCountry code by ISO 3166 alpha-2.
continentVARCHAR(255)NOT NULLContinent name.
statusENUMNOT NULLStatus of the resource (active or inactive). See Status for the possible values.
observed_atDATETIMENOT NULLTimestamp of the last observation.

Enums​

Status​

Last known status of a resource, e.g. active or inactive.

ValueDescription
ACTIVEActive and available resource.
INACTIVEUnavailable. For Server/Database: temporary or unknown cause.
PLANNED_FOR_RETIREMENTPlanned for retirement; only valid for Server and Database.
RETIREDNot orderable anymore, but prices may still exist (e.g. active multi-year contracts). Only valid for Server and Database.

Referenced by​