Scorm Table Schema (scorm)


Description

each table is one SCORM module and its configuration

scorm table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
scorm_aicc_session.scormid scoraiccsess_sco2_fk R
scorm_scoes.scorm scorscoe_sco2_fk R
scorm_scoes_track.scormid scorscoetrac_sco3_fk R
course BIGINT 19 0
name VARCHAR 255
scormtype VARCHAR 50 local

local, external or repository
reference VARCHAR 255
intro LONGTEXT 2147483647 null
introformat SMALLINT 5 0
version VARCHAR 9
maxgrade DOUBLE 22 0
grademethod TINYINT 3 0
whatgrade BIGINT 19 0
maxattempt BIGINT 19 1
forcecompleted BIT 1 0
forcenewattempt BIT 1 0
lastattemptlock BIT 1 0
masteryoverride BIT 1 1
displayattemptstatus BIT 1 1
displaycoursestructure BIT 1 0
updatefreq BIT 1 0

Define when the package must be automatically update
sha1hash VARCHAR 40 √ null

package content or ext path hash
md5hash VARCHAR 32

MD5 Hash of package file
revision BIGINT 19 0

revison number
launch BIGINT 19 0
skipview BIT 1 1
hidebrowse BIT 1 0
hidetoc BIT 1 0
nav BIT 1 1
navpositionleft BIGINT 19 √ -100
navpositiontop BIGINT 19 √ -100
auto BIT 1 0
popup BIT 1 0
options VARCHAR 255
width BIGINT 19 100
height BIGINT 19 600
timeopen BIGINT 19 0
timeclose BIGINT 19 0
timemodified BIGINT 19 0
completionstatusrequired BIT 1 √ null
completionscorerequired BIGINT 19 √ null
completionstatusallscos BIT 1 √ null
displayactivityname SMALLINT 5 1
autocommit BIT 1 0

Table contained -1 rows

scorm table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
scor_cou_ix Performance Asc course

scorm table relationships

Close relationships within degrees of separation