app_user
Description
Section titled “Description”A user of the translation CMS (an admin who writes and publishes translations), as known from the identity provider. Created on the first change the user makes and updated from the claims of the access token on every later change; the public_id is the id of a user reference in the API. Consumer applications read bundles through a service account and never appear here.
Columns
Section titled “Columns”| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | bigint | nextval(‘app_user_seq’::regclass) | false | public.release public.translation | ||
| public_id | uuid | gen_random_uuid() | false | |||
| subject | varchar(255) | false | Subject (“sub” claim) of the user at the identity provider. | |||
| display_name | varchar(100) | false | ||||
| 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 |
|---|---|---|
| app_user_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| uq_app_user_public_id | UNIQUE | UNIQUE (public_id) |
| uq_app_user_subject | UNIQUE | UNIQUE (subject) |
Indexes
Section titled “Indexes”| Name | Definition |
|---|---|
| app_user_pkey | CREATE UNIQUE INDEX app_user_pkey ON public.app_user USING btree (id) |
| uq_app_user_public_id | CREATE UNIQUE INDEX uq_app_user_public_id ON public.app_user USING btree (public_id) |
| uq_app_user_subject | CREATE UNIQUE INDEX uq_app_user_subject ON public.app_user USING btree (subject) |
Relations
Section titled “Relations”
Generated by tbls