message_argument

Description

An argument of a message key, which every translation of the key may use, in the order in which the generated code passes them.

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
message_key_id	bigint		false		public.message_key
position	integer		false
name	varchar(64)		false
argument_type	varchar(16)		false			The ICU type of the argument: NUMBER (number and plural), DATE, STRING (select) or ANY (plain placeholder).

Constraints

Name	Type	Definition
chk_message_argument_argument_type	CHECK	CHECK (((argument_type)::text = ANY ((ARRAY[‘ANY’::character varying, ‘NUMBER’::character varying, ‘DATE’::character varying, ‘STRING’::character varying])::text[])))
chk_message_argument_name	CHECK	CHECK (((name)::text ~ ‘^[A-Za-z][A-Za-z0-9_]*$’::text))
chk_message_argument_position	CHECK	CHECK ((“position” >= 0))
fk_message_argument_message_key_id	FOREIGN KEY	FOREIGN KEY (message_key_id) REFERENCES message_key(id)
message_argument_pkey	PRIMARY KEY	PRIMARY KEY (message_key_id, “position”)
uq_message_argument_message_key_id_name	UNIQUE	UNIQUE (message_key_id, name)

Indexes

Name	Definition
message_argument_pkey	CREATE UNIQUE INDEX message_argument_pkey ON public.message_argument USING btree (message_key_id, “position”)
uq_message_argument_message_key_id_name	CREATE UNIQUE INDEX uq_message_argument_message_key_id_name ON public.message_argument USING btree (message_key_id, name)

Relations

---

Generated by tbls