application

Description

An application whose texts are translated here, such as a Stratastax app. Its keys come from the translation files of the application; the CMS adds translations and publishes them as releases, which the application loads as bundles at startup. Invariant (application): the base locale is one of the locales of the application.

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	bigint	nextval(‘application_seq’::regclass)	false	public.application_locale public.message_key public.release
public_id	uuid	gen_random_uuid()	false
application_key	varchar(63)		false			The id of the application in the API and in the configuration of a consumer app (a slug such as match-tracker); never changes.
display_name	varchar(100)		false
base_locale	varchar(10)		false			Locale of the base texts of the keys, the source of truth in the translation files of the application.
created_at	timestamp with time zone	now()	false
updated_at	timestamp with time zone		true
version	bigint		false

Constraints

Name	Type	Definition
chk_application_application_key	CHECK	CHECK (((application_key)::text ~ ‘^[a-z][a-z0-9-]{1,62}$’::text))
chk_application_base_locale	CHECK	CHECK (((base_locale)::text ~ ‘^[a-z]{2,3}(-[A-Z]{2})?$’::text))
application_pkey	PRIMARY KEY	PRIMARY KEY (id)
uq_application_public_id	UNIQUE	UNIQUE (public_id)
uq_application_application_key	UNIQUE	UNIQUE (application_key)

Indexes

Name	Definition
application_pkey	CREATE UNIQUE INDEX application_pkey ON public.application USING btree (id)
uq_application_public_id	CREATE UNIQUE INDEX uq_application_public_id ON public.application USING btree (public_id)
uq_application_application_key	CREATE UNIQUE INDEX uq_application_application_key ON public.application USING btree (application_key)

Relations

---

Generated by tbls