scorm

0 rows


Description

each table is one SCORM module and its configuration

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
scorm_aicc_session.scormid scoraiccsess_sco2_fkR
scorm_attempt.scormid scoratte_sco2_fkR
scorm_scoes.scorm scorscoe_sco2_fkR
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
autocommit BIT 1 0

Indexes

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

Relationships