group_permission_assignment

106 rows


Description

Connects groups (user_group) and permissions (group_permission)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id MEDIUMINT UNSIGNED 8 √ null
group_id MEDIUMINT UNSIGNED 8 null
user_group.id group_permission_assignment_ibfk_1 R
permission_id MEDIUMINT UNSIGNED 8 null
group_permission.id group_permission_assignment_ibfk_2 R
create_time TIMESTAMP 19 current_timestamp()
update_time TIMESTAMP 19 current_timestamp()

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
group_id Performance Asc group_id
permission_id Performance Asc permission_id

Relationships

Close relationships within degrees of separation