Ltiservice Gradebookservices Table Schema (ltiservice_gradebookservices)


Description

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

ltiservice_gradebookservices table 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
course.id Implied Constraint R

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
lti.id ltisgrad_lti2_fk R

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

Table contained -1 rows

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

ltiservice_gradebookservices table relationships