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

Close relationships within degrees of separation