message_key
Description
Section titled “Description”A message of an application, with its text in the base locale, as imported from the translation files of the application. An import replaces the base text, description and arguments of every key it contains and marks every other key obsolete; a later import that contains the key again revives it. Invariant (application): an obsolete key is not published and is left out of every bundle. The version is the ETag of the key with its translations, so it goes up with every change of one of its translations as well.
Columns
Section titled “Columns”| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | bigint | nextval(‘message_key_seq’::regclass) | false | public.message_argument public.translation | ||
| public_id | uuid | gen_random_uuid() | false | |||
| application_id | bigint | false | public.application | |||
| message_key | varchar(200) | false | Dotted key, as in the translation files of the application (matchCreateCommand.gameId.label). | |||
| base_text | varchar(4000) | false | ||||
| description | varchar(1000) | true | ||||
| obsoleted_at | timestamp with time zone | true | When the last import no longer contained the key; null while the key is in use. | |||
| created_at | timestamp with time zone | now() | false | |||
| updated_at | timestamp with time zone | true | ||||
| version | bigint | false |
Constraints
Section titled “Constraints”| Name | Type | Definition |
|---|---|---|
| chk_message_key_message_key | CHECK | CHECK (((message_key)::text ~ ‘^[A-Za-z0-9_]+(.[A-Za-z0-9_]+)*$’::text)) |
| fk_message_key_application_id | FOREIGN KEY | FOREIGN KEY (application_id) REFERENCES application(id) |
| message_key_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| uq_message_key_public_id | UNIQUE | UNIQUE (public_id) |
| uq_message_key_application_id_message_key | UNIQUE | UNIQUE (application_id, message_key) |
Indexes
Section titled “Indexes”| Name | Definition |
|---|---|
| message_key_pkey | CREATE UNIQUE INDEX message_key_pkey ON public.message_key USING btree (id) |
| uq_message_key_public_id | CREATE UNIQUE INDEX uq_message_key_public_id ON public.message_key USING btree (public_id) |
| uq_message_key_application_id_message_key | CREATE UNIQUE INDEX uq_message_key_application_id_message_key ON public.message_key USING btree (application_id, message_key) |
Relations
Section titled “Relations”
Generated by tbls