groups
User groups for permission management and ownership.
| Name | Type | Nullable | Default Value | Notes |
|---|---|---|---|---|
PKID | integer | Group ID | ||
creator | integer | Creator user ID (defaults to authenticated user on creation) | ||
creationdate | bigint | date_part('epoch', now()) | Creation date and time as a Unix timestamp (defaults to current date and time on creation) | |
lastmodified | bigint | date_part('epoch', now()) | Last modification date and time as a Unix timestamp (auto-reset on modification) | |
leader users.ID | integer | Leader user ID | ||
activity | smallint | 0 | Activity (`0`=ACTIVE, `1`=DEACTIVATED, `2`=DELETED) | |
name | text | Name (case-insensitively unique) | ||
description | text | '' |
| Name | Unique | Nulls Distinct | Primary | Partial | Method | Keys |
|---|---|---|---|---|---|---|
| pk_groups | btree | ID | ||||
| s_groups_name | gin | name | ||||
| u_groups_name | btree | lower(name) |
| Name | Type |
|---|---|
| dc_groups_activity | check |
| dc_groups_description | check |
| dc_groups_name | check |
| fk_groups_leader | foreign_key |
| pk_groups | primary_key |
Loading...