Scorm Seq Ruleconds Table Schema (scorm_seq_ruleconds)


Description

SCORM2004 rule conditions

scorm_seq_ruleconds table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
scorm_seq_rulecond.ruleconditionsid scorseqrule_rul2_fk R
scoid BIGINT 19 0
scorm_scoes.id scorseqrule_sco3_fk R
conditioncombination VARCHAR 3 all
ruletype TINYINT 3 0
action VARCHAR 25

Table contained -1 rows

scorm_seq_ruleconds table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
scorseqrule_sco_ix Performance Asc scoid
scorseqrule_scoid_uix Must be unique Asc/Asc scoid + id

scorm_seq_ruleconds table relationships

Close relationships within degrees of separation