Scorm Aicc Session table / scorm_aicc_session - Moodle LMS 3.9 Database schema / Zoola Analytics

scorm_aicc_session table columns

Related columns Constraint Comments

Search:

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

Showing 1 to 12 of 12 entries

Table contained -1 rows

scorm_aicc_session table indexes

Search:

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

Showing 1 to 3 of 3 entries

Scorm Aicc Session Table Schema (scorm_aicc_session)

Description

scorm_aicc_session table columns

scorm_aicc_session table indexes

scorm_aicc_session table relationships

Close relationships within degrees of separation