Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||
| gradeitemid | BIGINT | 19 | null |
|
|
ID of the gradeItem related. |
||||
| courseid | BIGINT | 19 | null |
|
|
ID of the course related. |
||||
| toolproxyid | BIGINT | 19 | √ | null |
|
|
ID of the Tool Proxy instance. |
|||
| typeid | BIGINT | 19 | √ | null |
|
|
ID of the LTI Type if not Proxy. |
|||
| baseurl | LONGTEXT | 2147483647 | √ | null |
|
|
Lineitem URL that will be returned to the Tool provider |
|||
| ltilinkid | BIGINT | 19 | √ | null |
|
|
ID of the LTI element related with this lineitem. |
|||
| resourceid | VARCHAR | 512 | √ | null |
|
|
Resource id for the line item |
|||
| tag | VARCHAR | 255 | √ | null |
|
|
Tag type specified for the line item |
|||
| subreviewurl | LONGTEXT | 2147483647 | √ | null |
|
|
Submission review URL |
|||
| subreviewparams | LONGTEXT | 2147483647 | √ | null |
|
|
Submission review custom params |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| ltisgrad_gracou2_ix | Performance | Asc/Asc | gradeitemid + courseid |
| ltisgrad_lti2_ix | Performance | Asc | ltilinkid |