app_group
Description
Section titled “Description”A named roster of users, owned by one user, used for privileged access and community admins. Soft-deleted: a deleted group grants nothing any more, although its rows still exist.
Columns
Section titled “Columns”| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | bigint | nextval(‘app_group_seq’::regclass) | false | public.group_member public.community public.privacy_setting_group | ||
| public_id | uuid | gen_random_uuid() | false | |||
| owner_user_id | bigint | false | public.app_user | |||
| display_name | varchar(100) | false | ||||
| created_at | timestamp with time zone | now() | false | |||
| updated_at | timestamp with time zone | true | ||||
| deleted_at | timestamp with time zone | true | ||||
| version | bigint | false |
Constraints
Section titled “Constraints”| Name | Type | Definition |
|---|---|---|
| fk_app_group_owner_user_id | FOREIGN KEY | FOREIGN KEY (owner_user_id) REFERENCES app_user(id) |
| app_group_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| uq_app_group_public_id | UNIQUE | UNIQUE (public_id) |
Indexes
Section titled “Indexes”| Name | Definition |
|---|---|
| app_group_pkey | CREATE UNIQUE INDEX app_group_pkey ON public.app_group USING btree (id) |
| uq_app_group_public_id | CREATE UNIQUE INDEX uq_app_group_public_id ON public.app_group USING btree (public_id) |
| ix_app_group_owner_user_id | CREATE INDEX ix_app_group_owner_user_id ON public.app_group USING btree (owner_user_id) |
Relations
Section titled “Relations”
Generated by tbls