Scorm Scoes Track Table Schema (scorm_scoes_track)


Description

to track SCOes

scorm_scoes_track table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
userid BIGINT 19 0
user.id Implied Constraint R
scormid BIGINT 19 0
scorm.id scorscoetrac_sco3_fk R
scoid BIGINT 19 0
scorm_scoes.id scorscoetrac_sco4_fk R
attempt BIGINT 19 1
element VARCHAR 255
value LONGTEXT 2147483647 null
timemodified BIGINT 19 0

Table contained -1 rows

scorm_scoes_track table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
scorscoetrac_sco2_ix Performance Asc scoid
scorscoetrac_sco_ix Performance Asc scormid
scorscoetrac_use_ix Performance Asc userid
scorscoetrac_usescoscoatte_uix Must be unique Asc/Asc/Asc/Asc/Asc userid + scormid + scoid + attempt + element

scorm_scoes_track table relationships

Close relationships within degrees of separation