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_lti3_ix | Performance | Asc | ltideploymentid |
| enroltiresolink_lti4_ix | Performance | Asc | lticontextid |
| enroltiresolink_reslti2_uix | Must be unique | Asc/Asc | resourcelinkid + ltideploymentid |
Relationships
Close relationships within degrees of separation
