# enrol_lti_resource_link

0 rows

### Description

Each row represents a resource link for a platform and deployment

### Columns

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 |  |  |

### 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

### Relationships