release
Description
Section titled “Description”A publication of the draft translations of an application, numbered from 1 per application. A release never changes: the bundle of a locale is the published text of every key in it, with the number of the latest release of that locale as its version. Invariant (application): a release publishes only locales of its application, and no translation whose arguments no longer match its key.
Columns
Section titled “Columns”| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | bigint | nextval(‘release_seq’::regclass) | false | public.release_locale public.translation | ||
| public_id | uuid | gen_random_uuid() | false | |||
| application_id | bigint | false | public.application | |||
| release_number | integer | false | Sequence number of the release within its application, the version of a release and of a bundle in the API. | |||
| note | varchar(500) | true | ||||
| message_count | integer | false | Number of translations whose draft this release published. | |||
| published_at | timestamp with time zone | false | ||||
| published_by_user_id | bigint | false | public.app_user | |||
| created_at | timestamp with time zone | now() | false | |||
| updated_at | timestamp with time zone | true |
Constraints
Section titled “Constraints”| Name | Type | Definition |
|---|---|---|
| chk_release_message_count | CHECK | CHECK ((message_count >= 0)) |
| chk_release_release_number | CHECK | CHECK ((release_number >= 1)) |
| fk_release_published_by_user_id | FOREIGN KEY | FOREIGN KEY (published_by_user_id) REFERENCES app_user(id) |
| fk_release_application_id | FOREIGN KEY | FOREIGN KEY (application_id) REFERENCES application(id) |
| release_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| uq_release_public_id | UNIQUE | UNIQUE (public_id) |
| uq_release_application_id_release_number | UNIQUE | UNIQUE (application_id, release_number) |
Indexes
Section titled “Indexes”| Name | Definition |
|---|---|
| release_pkey | CREATE UNIQUE INDEX release_pkey ON public.release USING btree (id) |
| uq_release_public_id | CREATE UNIQUE INDEX uq_release_public_id ON public.release USING btree (public_id) |
| uq_release_application_id_release_number | CREATE UNIQUE INDEX uq_release_application_id_release_number ON public.release USING btree (application_id, release_number) |
| ix_release_published_by_user_id | CREATE INDEX ix_release_published_by_user_id ON public.release USING btree (published_by_user_id) |
Relations
Section titled “Relations”
Generated by tbls