app.chat_message_translations
TableRow level security on
Machine translations of chat messages (Section 4.9), one per message and reader language, cached so each is translated once. Written only by the translation service while the org has communication.message_translation on; readable by the conversation's members.
Primary key: id
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| org_id | uuid | No | Owning org, derived from app.chat_messages on insert; never accepted from the caller and never changed.References app.organizations.id |
| chat_message_id | uuid | No | Message translated. Deleting the message deletes its translations (1392).References app.chat_messages.id |
| target_language | text | No | Language of the translation (BCP 47), the reader's language. |
| source_language | text | Yes | Language the message was written in, as stored or as the provider detected it. |
| body | text | No | Translated text. |
| provider | text | No | Translation provider, for example google. |
| created_at | timestamp with time zone | No | When the row was inserted. Set by the database. |
| created_by | uuid | Yes | Person who inserted the row, or null for a platform process. Set by the database.References app.people.id |
| updated_at | timestamp with time zone | No | When the row last changed. Set by the database. |
| updated_by | uuid | Yes | Person who last changed the row, or null for a platform process. Set by the database.References app.people.id |
| deleted_at | timestamp with time zone | Yes | Soft delete time. A row with deleted_at set is ignored by every access helper. |