Skip to main content

Primary key

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

Specific attributes

internal
varcharpublicuniquerequired
The internal code or identifier for the city.
Rules: Max length: 50 characters
latitude
numericpublic
The latitude coordinate of the city.
Rules: Precision: 12, Scale: 8
longitude
numericpublic
The longitude coordinate of the city.
Rules: Precision: 12, Scale: 8
name
varcharpublicrequired
The name of the city.
Rules: Max length: 150 characters
reference
varcharpublic
A reference or additional identifier for the city.
Rules: Max length: 100 characters
wikidata_id
varcharpublic
The Wikidata identifier for the city, if available.
Rules: Max length: 50 characters

Foreign keys

country
uuidpublicrequired
The unique identifier of the associated country. Ref: Country Schema
state
uuidpublicrequired
The unique identifier of the associated state. Ref: State Schema

Tracking attributes

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