content_translation


Description

{“what”:“Translation pairs mapping source strings to localized text per locale.”,“why”:“Without it, content cannot be displayed in multiple languages.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:03.102622551+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null

{“what”:“Unique integer identifier for each translation row.”,“why”:“Without it, rows cannot be uniquely referenced or updated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:03.142118384+00:00”}

locale varchar 5 null

{“what”:“Language code such as ‘en’ or ‘fr’ for the translation.”,“why”:“Without it, translations cannot be matched to a specific language.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:03.174419426+00:00”}

msgid text 2147483647 null

{“what”:“Source string in the original language to be translated.”,“why”:“Without it, there is no reference to which text is being translated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:03.238351561+00:00”}

msgstr text 2147483647 null

{“what”:“Translated text for the given locale and msgid.”,“why”:“Without it, the translation itself is missing, making the row useless.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:07:03.264430001+00:00”}

Indexes

Constraint Name Type Sort Column(s)
content_translation_pkey Primary key Asc id

Relationships