public.user_group¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | uuid | false | public.user_group_club public.member public.discount | (DC2Type:uuid) | ||
| public_name | varchar(255) | false | ||||
| internal_name | varchar(60) | false | ||||
| note | text | true | ||||
| created_at | timestamp(0) with time zone | false | (DC2Type:datetimetz_immutable) | |||
| type | varchar(255) | NULL::character varying | false | |||
| invite_code | varchar(10) | true | ||||
| deactivated_by_id | uuid | true | public.user | (DC2Type:uuid) | ||
| deactivated_at | timestamp(0) with time zone | NULL::timestamp with time zone | true | (DC2Type:datetimetz_immutable) | ||
| active | boolean | true | false |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| fk_8f02bf9dbdc76baa | FOREIGN KEY | FOREIGN KEY (deactivated_by_id) REFERENCES "user"(id) |
| user_group_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes¶
| Name | Definition |
|---|---|
| user_group_pkey | CREATE UNIQUE INDEX user_group_pkey ON public.user_group USING btree (id) |
| uniq_8f02bf9d6f21f112 | CREATE UNIQUE INDEX uniq_8f02bf9d6f21f112 ON public.user_group USING btree (invite_code) |
| idx_8f02bf9dbdc76baa | CREATE INDEX idx_8f02bf9dbdc76baa ON public.user_group USING btree (deactivated_by_id) |
Relations¶
Generated by tbls