Scorm Aicc Session Table Schema (scorm_aicc_session)


Description

Used by AICC HACP to store session information

scorm_aicc_session table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
userid BIGINT 19 0
user.id scoraiccsess_use2_fk R

id from user table

scormid BIGINT 19 0
scorm.id scoraiccsess_sco2_fk R

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

Table contained -1 rows

scorm_aicc_session table indexes

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

scorm_aicc_session table relationships