0 rows


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_1C

link to the agreement

license_id INT 10 null
erm_licenses.license_id erm_user_roles_ibfk_2C

link to the license

user_id INT 10 null
borrowers.borrowernumber erm_user_roles_ibfk_3C

link to the user

role VARCHAR 80 null

role of the user


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