erm_user_roles

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 5 of 5 entries

Indexes

Search:

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

Showing 1 to 4 of 4 entries

Columns

Indexes

Relationships

Close relationships within degrees of separation