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

id from user table

scormid BIGINT 19 0
scorm.id scoraiccsess_sco2_fkR

id from scorm table

hacpsession VARCHAR 255

sessionid used to authenticate AICC HACP communication

scoid BIGINT 19 0

id from scorm_scoes table

scormmode VARCHAR 50 null
scormstatus VARCHAR 255 null
attempt BIGINT 19 null
lessonstatus VARCHAR 255 null
sessiontime VARCHAR 255 null
timecreated BIGINT 19 0

time this session was created

timemodified BIGINT 19 0

time this session was last used

Indexes

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

Relationships