Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| group_id | BIGINT | 19 | null |
|
|
|||||
| item_id | BIGINT | 19 | null |
|
|
|||||
| can_view_generated | enum('none', 'info', 'content', 'content_with_descendants', 'solution') | 24 | none |
|
|
The aggregated level of visibility the group has on the item |
||||
| can_grant_view_generated | enum('none', 'enter', 'content', 'content_with_descendants', 'solution', 'solution_with_grant') | 24 | none |
|
|
The aggregated level of visibility that the group can give on this item to other groups on which it has the right to |
||||
| can_watch_generated | enum('none', 'result', 'answer', 'answer_with_grant') | 17 | none |
|
|
The aggregated level of observation a group has for an item, on the activity of the users he can watch |
||||
| can_edit_generated | enum('none', 'children', 'all', 'all_with_grant') | 14 | none |
|
|
The aggregated level of edition permissions a group has on an item |
||||
| is_owner_generated | BIT | 1 | 0 |
|
|
Whether the group is the owner of this item. Implies the maximum level in all of the above permissions. Can delete the item. |
||||
| can_view_generated_value | TINYINT UNSIGNED | 3 | null |
|
|
can_view_generated as an integer (to use comparison operators) |
||||
| can_grant_view_generated_value | TINYINT UNSIGNED | 3 | null |
|
|
can_grant_view_generated as an integer (to use comparison operators) |
||||
| can_watch_generated_value | TINYINT UNSIGNED | 3 | null |
|
|
can_watch_generated as an integer (to use comparison operators) |
||||
| can_edit_generated_value | TINYINT UNSIGNED | 3 | null |
|
|
can_edit_generated 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 + item_id |
| item_id | Performance | Asc | item_id |
Relationships
Close relationships within degrees of separation
