user_user_groups


Description

Maps users to their assigned user_groups.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_user_group_id BIGINT UNSIGNED 20 null
user_group_id BIGINT 19 null
user_groups.user_group_id user_user_groups_user_group_id_foreignC
user_id BIGINT 19 null
users.user_id user_user_groups_user_idC

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc user_user_group_id
user_user_groups_unique Must be unique Asc/Asc user_group_id + user_id
user_user_groups_user_group_id Performance Asc user_group_id
user_user_groups_user_id Performance Asc user_id

Relationships