permissions_granted


Description

Raw permissions given to a group on an item

Columns

Column Type Size Nulls Auto Default Children Parents Comments
group_id BIGINT 19 null
groups.id fk_permissions_granted_group_id_groups_id C
item_id BIGINT 19 null
items.id fk_permissions_granted_item_id_items_id C
source_group_id BIGINT 19 null
groups.id fk_permissions_granted_source_group_id_groups_id C
origin enum('group_membership', 'item_unlocking', 'self', 'other') 16 null
latest_update_at DATETIME 19 CURRENT_TIMESTAMP

Last time one of the attributes has been modified
can_view enum('none', 'info', 'content', 'content_with_descendants', 'solution') 24 none

The level of visibility the group has on the item
can_enter_from DATETIME 19 9999-12-31 23:59:59

Time from which the group can “enter” this item, superseded by items.entering_time_min
can_enter_until DATETIME 19 9999-12-31 23:59:59

Time until which the group can “enter” this item, superseded by items.entering_time_max
can_grant_view enum('none', 'enter', 'content', 'content_with_descendants', 'solution', 'solution_with_grant') 24 none

The level of visibility that the group can give on this item to other groups on which it has the right to
can_watch enum('none', 'result', 'answer', 'answer_with_grant') 17 none

The level of observation a group has for an item, on the activity of the users he can watch
can_edit enum('none', 'children', 'all', 'all_with_grant') 14 none

The level of edition permissions a group has on an item
can_make_session_official BIT 1 0

Whether the group is allowed to associate official sessions to this item
is_owner 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_value TINYINT UNSIGNED 3 null

can_view as an integer (to use comparison operators)
can_grant_view_value TINYINT UNSIGNED 3 null

can_grant_view as an integer (to use comparison operators)
can_watch_value TINYINT UNSIGNED 3 null

can_watch as an integer (to use comparison operators)
can_edit_value TINYINT UNSIGNED 3 null

can_edit as an integer (to use comparison operators)
can_request_help_to BIGINT 19 √ null
groups.id fk_can_request_help_to_groups_id N

Whether the group can create a forum thread accessible to the pointed group. NULL = no rights to create.

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc/Asc/Asc group_id + item_id + source_group_id + origin
fk_can_request_help_to_groups_id Performance Asc can_request_help_to
fk_permissions_granted_item_id_items_id Performance Asc item_id
fk_permissions_granted_source_group_id_groups_id Performance Asc source_group_id
group_id_item_id Performance Asc/Asc group_id + item_id

Relationships

Close relationships within degrees of separation