Scorm Seq Mapinfo Table Schema (scorm_seq_mapinfo)


Description

SCORM2004 objective mapinfo description

scorm_seq_mapinfo table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
scoid BIGINT 19 0
scorm_scoes.id scorseqmapi_sco2_fk R
objectiveid BIGINT 19 0
scorm_seq_objective.id scorseqmapi_obj2_fk R
targetobjectiveid BIGINT 19 0
readsatisfiedstatus BIT 0 1
readnormalizedmeasure BIT 0 1
writesatisfiedstatus BIT 0 0
writenormalizedmeasure BIT 0 0

Table contained -1 rows

scorm_seq_mapinfo table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
scorseqmapi_obj_ix Performance Asc objectiveid
scorseqmapi_sco_ix Performance Asc scoid
scorseqmapi_scoidobj_uix Must be unique Asc/Asc/Asc scoid + id + objectiveid

scorm_seq_mapinfo table relationships