user_group

37 rows


Description

List of all user groups. Some of them are only informative (i.e. council of setons on website), others for permissions system.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id MEDIUMINT UNSIGNED 8 √ null
group_permission_assignment.group_id group_permission_assignment_ibfk_1 R
user_group.parent_group_id user_group_ibfk_1 R
user_group_assignment.group_id user_group_assignment_ibfk_2 R
technical_name VARCHAR 100 null

hardcoded names to be used in code
parent_group_id MEDIUMINT UNSIGNED 8 √ null
user_group.id user_group_ibfk_1 R
public BIT 1 null

Public groups are visible for everyone, the rest only for internal permissions
create_time TIMESTAMP 19 current_timestamp()
update_time TIMESTAMP 19 current_timestamp()
name_key VARCHAR 100 null

name key of user group in translation table

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
parent_group_key Performance Asc parent_group_id

Relationships

Close relationships within degrees of separation