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