Scorm Seq Rulecond Table Schema (scorm_seq_rulecond)


Description

SCORM2004 rule condition

scorm_seq_rulecond table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
scoid BIGINT 19 0
scorm_scoes.id scorseqrule_sco4_fk R
ruleconditionsid BIGINT 19 0
scorm_seq_ruleconds.id scorseqrule_rul2_fk R
refrencedobjective VARCHAR 255
measurethreshold FLOAT 11,4 0.0000
operator VARCHAR 5 noOp
cond VARCHAR 30 always

Table contained -1 rows

scorm_seq_rulecond table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
scorseqrule_idscorul_uix Must be unique Asc/Asc/Asc id + scoid + ruleconditionsid
scorseqrule_rul_ix Performance Asc ruleconditionsid
scorseqrule_sco2_ix Performance Asc scoid

scorm_seq_rulecond table relationships

Close relationships within degrees of separation