erm_user_roles

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_role_id INT 10 √ null

primary key
agreement_id INT 10 √ null
erm_agreements.agreement_id erm_user_roles_ibfk_1 C

link to the agreement
license_id INT 10 √ null
erm_licenses.license_id erm_user_roles_ibfk_2 C

link to the license
user_id INT 10 null
borrowers.borrowernumber erm_user_roles_ibfk_3 C

link to the user
role VARCHAR 80 null

role of the user

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc user_role_id
erm_user_roles_ibfk_1 Performance Asc agreement_id
erm_user_roles_ibfk_2 Performance Asc license_id
erm_user_roles_ibfk_3 Performance Asc user_id

Relationships

Close relationships within degrees of separation