xapi_states

0 rows


Description

The stored xAPI states

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
component VARCHAR 255

The component name

userid BIGINT 19 null
itemid BIGINT 19 null

The Agent Id (usually the plugin instance)

stateid VARCHAR 255

Component identified for the state data

statedata LONGTEXT 2147483647 null

JSON state data

registration VARCHAR 255 null

Optional registration identifier

timecreated BIGINT 19 null
timemodified BIGINT 19 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
xapistat_comite_ix Performance Asc/Asc component + itemid
xapistat_tim_ix Performance Asc timemodified
xapistat_use_ix Performance Asc userid