cloud.dictionary_translations
Schema: cloud
English table: cloud.dictionary_translations
Italian original table: cloud._translate
Description: System dictionary for UI multi-language support, including gender and number inflections.
Overview
- Columns: 8
- Primary key: tr_translation_id
- Outgoing foreign keys: 1
- Incoming foreign keys: 0
- Indexes: 1
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
tr_translation_id | trans_id | integer | NO | Unique identifier for the translation entry. | |
tr_context_code | trans_context | character varying | NO | Namespace or module context (e.g., "ERRORS", "MENU", "BUTTONS"). | |
tr_language_id | trans_language | smallint | NO | Reference to the target language (cloud.languages). | |
tr_source_key | trans_base_string | character varying | NO | The base string or key to be translated. | |
tr_value_masculine_singular | trans_ms | character varying | NO | Translated value: Masculine Singular. | |
tr_value_feminine_singular | trans_fs | character varying | YES | Translated value: Feminine Singular (optional). | |
tr_value_masculine_plural | trans_mp | character varying | YES | Translated value: Masculine Plural (optional). | |
tr_value_feminine_plural | trans_fp | character varying | YES | Translated value: Feminine Plural (optional). |
Relationships
Outgoing foreign keys
| Constraint | Local columns | References | Referenced columns | On update | On delete |
|---|---|---|---|---|---|
fk_tr_language | tr_language_id | cloud.languages | lng_language_id |
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_dictionary_translations→tr_translation_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_tr_context_lang_key | NO | btree | tr_context_code, tr_language_id, tr_source_key |
Navigation
- Back to main index
- [Back to
cloudindex]../)