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

Close relationships within degrees of separation