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_gracou_ix | Performance | Asc/Asc | gradeitemid + courseid |
ltisgrad_lti_ix | Performance | Asc | ltilinkid |