public.group¶
Description¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | uuid | false | Unique identifier for the group(DC2Type:uuid) | |||
| club_id | uuid | true | public.club | Club associated with this group (null for global groups)(DC2Type:uuid) | ||
| name | varchar(255) | false | Display name of the group | |||
| keycloak_id | uuid | true | Reference to the corresponding group in Keycloak identity provider(DC2Type:uuid) | |||
| role_id | uuid | false | public.role | Role assigned to members of this group(DC2Type:uuid) |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| fk_6dc044c561190a32 | FOREIGN KEY | FOREIGN KEY (club_id) REFERENCES club(id) |
| group_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| fk_6dc044c5d60322ac | FOREIGN KEY | FOREIGN KEY (role_id) REFERENCES role(id) |
Indexes¶
| Name | Definition |
|---|---|
| group_pkey | CREATE UNIQUE INDEX group_pkey ON public."group" USING btree (id) |
| idx_6dc044c561190a32 | CREATE INDEX idx_6dc044c561190a32 ON public."group" USING btree (club_id) |
| idx_6dc044c5d60322ac | CREATE INDEX idx_6dc044c5d60322ac ON public."group" USING btree (role_id) |
| uniq_6dc044c561190a32d60322ac | CREATE UNIQUE INDEX uniq_6dc044c561190a32d60322ac ON public."group" USING btree (club_id, role_id) |
Relations¶
Generated by tbls