Scorm Seq Rolluprulecond Table Schema (scorm_seq_rolluprulecond)


Description

SCORM2004 sequencing rule

scorm_seq_rolluprulecond table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
scoid BIGINT 19 0
scorm_scoes.id scorseqroll_sco4_fk R
rollupruleid BIGINT 19 0
scorm_seq_rolluprule.id scorseqroll_rol2_fk R
operator VARCHAR 5 noOp
cond VARCHAR 25

Table contained -1 rows

scorm_seq_rolluprulecond table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
scorseqroll_rol_ix Performance Asc rollupruleid
scorseqroll_sco2_ix Performance Asc scoid
scorseqroll_scorolid_uix Must be unique Asc/Asc/Asc scoid + rollupruleid + id

scorm_seq_rolluprulecond table relationships

Close relationships within degrees of separation