0 rows


Used by AICC HACP to store session information


Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
userid BIGINT 19 0 scoraiccsess_use2_fkR

id from user table

scormid BIGINT 19 0 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


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