Skip to main content

​
Primary key

document_id
uuiddefault:"Random UUID"publicrequired
The unique identifier for the country record.

​
Specific attributes

capital
varcharpublic
The capital city of the country.
Rules: Max length: 150 characters
emoji
varcharpublicrequired
The emoji representation of the country’s flag.
Rules: Max length: 25 characters
emoji_u
varcharpublicrequired
The Unicode representation of the country’s flag emoji.
Rules: Max length: 50 characters
iso2
varcharpublicrequired
The ISO 3166-1 alpha-2 code of the country.
Rules: Max length: 2 characters
iso3
varcharpublicrequired
The ISO 3166-1 alpha-3 code of the country.
Rules: Max length: 3 characters
latitude
numericpublicrequired
The latitude coordinate of the country’s center point.
Rules: Precision: 12, Scale: 8
longitude
numericpublicrequired
The longitude coordinate of the country’s center point.
Rules: Precision: 12, Scale: 8
name
varcharpublicrequired
The name of the country.
Rules: Max length: 150 characters
nationality
varcharpublicrequired
The nationality of the country’s citizens.
Rules: Max length: 150 characters
native
varcharpublic
The native name of the country in its local language.
Rules: Max length: 150 characters
numeric_code
varcharpublicrequired
The ISO 3166-1 numeric code of the country.
Rules: Max length: 5 characters
phone_code
varcharpublicrequired
The country’s international phone code.
Rules: Max length: 5 characters
reference
varcharpublic
A reference or additional identifier for the country.
Rules: Max length: 100 characters
tld
varcharpublicrequired
The top-level domain (TLD) of the country.
Rules: Max length: 25 characters
wikidata_id
varcharpublic
The Wikidata identifier for the country, if available.
Rules: Max length: 50 characters

​
Tracking attributes

created_at
timestamppublic
The timestamp when the country record was created.
Rules: Precision: 6, with timezone
deleted_at
timestamppublic
The timestamp when the country record was deleted, if applicable.
Rules: Precision: 6, with timezone
is_actived
booleandefault:"true"public
Indicates whether the country record is active.
is_deleted
booleandefault:"false"public
Indicates whether the country record has been deleted.
updated_at
timestamppublic
The timestamp when the country record was last updated.
Rules: Precision: 6, with timezone