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 |