Skip to main content

​
Primary key

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

​
Specific attributes

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

​
Foreign keys

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

​
Tracking attributes

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