Lti Tool Proxies Table Schema (lti_tool_proxies)


Description

LTI tool proxy registrations

lti_tool_proxies table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
lti_tool_settings.toolproxyid ltitoolsett_too2_fk R
name VARCHAR 255 Tool Provider

Tool Provider name
regurl LONGTEXT 2147483647 √ null
state TINYINT 3 1

Configured = 1, Pending = 2, Accepted = 3, Rejected = 4, Cancelled = 5
guid VARCHAR 255 √ null
secret VARCHAR 255 √ null
vendorcode VARCHAR 255 √ null
capabilityoffered LONGTEXT 2147483647 null

List of capabilities offered, one per line
serviceoffered LONGTEXT 2147483647 null

List of services offered, one per line
toolproxy LONGTEXT 2147483647 √ null

JSON string representing tool proxy returned by tool provider
createdby BIGINT 19 null

ID of user which initiated the registration process
timecreated BIGINT 19 null

Date/time at which the record was created
timemodified BIGINT 19 null

Date/time at which the record was last modified

Table contained -1 rows

lti_tool_proxies table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
ltitoolprox_gui_uix Must be unique Asc guid

lti_tool_proxies table relationships

Close relationships within degrees of separation