enrol_lti_user_resource_link

0 rows


Description

Join table mapping users to resource links as this is a many:many relationship

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
ltiuserid BIGINT 19 null
enrol_lti_users.id enroltiuserresolink_lti2_fkR

The id of the enrol_lti_users record

resourcelinkid BIGINT 19 null
enrol_lti_resource_link.id enroltiuserresolink_res2_fkR

The id of the enrol_lti_resource_link record.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
enroltiuserresolink_lti_ix Performance Asc ltiuserid
enroltiuserresolink_ltires_uix Must be unique Asc/Asc ltiuserid + resourcelinkid
enroltiuserresolink_res_ix Performance Asc resourcelinkid

Relationships