0 rows


Each row represents a resource link for a platform and deplo


Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
enrol_lti_user_resource_link.resourcelinkid enroltiuserresolink_res2_fkR
resourcelinkid VARCHAR 255

The platform-and-deployment-unique id of the resource link

ltideploymentid BIGINT 19 null
enrol_lti_deployment.id enroltiresolink_lti3_fkR

The id of the enrol_lti_deployment record containing the deployment information.

resourceid BIGINT 19 null
resource.id Implied ConstraintR

The id of the local enrol_lti_tools record containing information about the published resource to which this resource link relates.

lticontextid BIGINT 19 null
enrol_lti_context.id enroltiresolink_lti4_fkR

The id of the enrol_lti_context record containing information about the context from which this resource link originates.

lineitemsservice VARCHAR 1333 null

The URL for the line items service for this resource link

lineitemservice VARCHAR 1333 null

The URL for the line item service (if only one line item present).

lineitemscope VARCHAR 255 null

The ags line items authorization scope

resultscope VARCHAR 255 null

The ags result authorization scope

scorescope VARCHAR 255 null

The ags score items authorization scope

contextmembershipsurl VARCHAR 1333 null

The NRPS membership URL

nrpsserviceversions VARCHAR 255 null

The NRPS supported service versions

timecreated BIGINT 19 null
timemodified BIGINT 19 null


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
enroltiresolink_lti3_ix Performance Asc ltideploymentid
enroltiresolink_lti4_ix Performance Asc lticontextid
enroltiresolink_reslti2_uix Must be unique Asc/Asc resourcelinkid + ltideploymentid