Lti Access Tokens Table Schema (lti_access_tokens)


Description

Security tokens for accessing of LTI services

lti_access_tokens table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
typeid BIGINT 19 null
lti_types.id ltiaccetoke_typ2_fk R

Basic LTI type id

scope LONGTEXT 2147483647 null

Scope values as JSON array

token VARCHAR 128

security token, aka private access key

validuntil BIGINT 19 null

timestamp - valid until data

timecreated BIGINT 19 null

created timestamp

lastaccess BIGINT 19 null

last access timestamp

Table contained -1 rows

lti_access_tokens table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
ltiaccetoke_tok_uix Must be unique Asc token
ltiaccetoke_typ_ix Performance Asc typeid

lti_access_tokens table relationships