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 0 0
forcenewattempt BIT 0 0
lastattemptlock BIT 0 0
masteryoverride BIT 0 1
displayattemptstatus BIT 0 1
displaycoursestructure BIT 0 0
updatefreq BIT 0 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 0 1
hidebrowse BIT 0 0
hidetoc BIT 0 0
nav BIT 0 1
navpositionleft BIGINT 19 -100
navpositiontop BIGINT 19 -100
auto BIT 0 0
popup BIT 0 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 0 null
completionscorerequired BIGINT 19 null
completionstatusallscos BIT 0 null
displayactivityname SMALLINT 5 1
autocommit BIT 0 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