sys_role_users


Columns

Column Type Size Nulls Auto Default Children Parents Comments
role_user_id INT 10 √ null
role_id INT 10 null
sys_roles.role_id FK553305B1839C9EC3 R
user_id INT 10 null
sys_users.user_id FK553305B128C762A3 C

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc role_user_id
FK553305B128C762A3 Performance Asc user_id
FK553305B1839C9EC3 Performance Asc role_id
user_id_2 Must be unique Asc/Asc user_id + role_id

Relationships

Close relationships within degrees of separation