Scorm Scoes Table Schema (scorm_scoes)


Description

each SCO part of the SCORM module

scorm_scoes table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
scorm_scoes_data.scoid scorscoedata_sco2_fk R
scorm_scoes_track.scoid scorscoetrac_sco4_fk R
scorm_seq_mapinfo.scoid scorseqmapi_sco2_fk R
scorm_seq_objective.scoid scorseqobje_sco2_fk R
scorm_seq_rolluprule.scoid scorseqroll_sco3_fk R
scorm_seq_rolluprulecond.scoid scorseqroll_sco4_fk R
scorm_seq_rulecond.scoid scorseqrule_sco4_fk R
scorm_seq_ruleconds.scoid scorseqrule_sco3_fk R
scorm BIGINT 19 0
scorm.id scorscoe_sco2_fk R
manifest VARCHAR 255
organization VARCHAR 255
parent VARCHAR 255
identifier VARCHAR 255
launch LONGTEXT 2147483647 null
scormtype VARCHAR 5
title VARCHAR 255
sortorder BIGINT 19 0

order of scoes

Table contained -1 rows

scorm_scoes table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
scorscoe_sco_ix Performance Asc scorm

scorm_scoes table relationships

Close relationships within degrees of separation