roles

2 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
organization_id VARCHAR 100 null
organizations.id roles_organization_id_foreignR
department_id CHAR 36 null
departments.department_id roles_department_id_foreignR
employee_id CHAR 36 null
role VARCHAR 20 null
employee_roles.role roles_employee_role_role_foreignR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc/Asc/Asc organization_id + department_id + employee_id + role
roles_department_id_foreign Performance Asc department_id
roles_employee_role_role_foreign Performance Asc role

Relationships

Close relationships within degrees of separation