scorm_aicc_session

0 rows


Description

Used by AICC HACP to store session information

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
userid BIGINT 19 0
user.id scoraiccsess_use2_fkR
scormid BIGINT 19 0
scorm.id scoraiccsess_sco2_fkR
hacpsession VARCHAR 255
scoid BIGINT 19 0
scormmode VARCHAR 50 null
scormstatus VARCHAR 255 null
attempt BIGINT 19 null
lessonstatus VARCHAR 255 null
sessiontime VARCHAR 255 null
timecreated BIGINT 19 0
timemodified BIGINT 19 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
scoraiccsess_sco4_ix Performance Asc scormid
scoraiccsess_use4_ix Performance Asc userid

Relationships