0 rows


This file records the grade items created by the LTI Gradebook Services service


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

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 ltisgrad_lti2_fkR

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


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