Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| group_id | BIGINT | 19 | null |
|
|
|||||
| manager_id | BIGINT | 19 | null |
|
|
|||||
| can_manage | enum('none', 'memberships', 'memberships_and_group') | 21 | none |
|
|
|||||
| can_grant_group_access | BIT | 1 | 0 |
|
|
Can give members access rights to some items (requires the giver to be allowed to give this permission on the item) |
||||
| can_watch_members | BIT | 1 | 0 |
|
|
Can watch members’ submissions on items. Requires the watcher to be allowed to watch this item. For members who have agreed |
||||
| can_edit_personal_info | BIT | 1 | 0 |
|
|
Can change member’s personal info, for those who have agreed (not visible to managers, only for specific uses) |
||||
| can_manage_value | TINYINT UNSIGNED | 3 | null |
|
|
can_manage as an integer (to use comparison operators) |
Table contained 0 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc/Asc | group_id + manager_id |
| fk_group_managers_manager_id_groups_id | Performance | Asc | manager_id |
Relationships
Close relationships within degrees of separation
