Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
id | BIGINT | 19 | √ | null |
|
|
||||
resourcelinkid | VARCHAR | 255 |
|
|
The platform-and-deployment-unique id of the resource link |
|||||
ltideploymentid | BIGINT | 19 | null |
|
|
The id of the enrol_lti_deployment record containing the deployment information. |
||||
resourceid | BIGINT | 19 | null |
|
|
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 |
|
|
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 |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PRIMARY | Primary key | Asc | id |
enroltiresolink_lti2_ix | Performance | Asc | lticontextid |
enroltiresolink_lti_ix | Performance | Asc | ltideploymentid |
enroltiresolink_reslti_uix | Must be unique | Asc/Asc | resourcelinkid + ltideploymentid |