SCORM schema: Difference between revisions

Latest revision as of 20:25, 24 July 2013

This page explains the files involved in displaying a SCORM package - it is mainly useful for developers.

The names of files in the images below are a slightly out of date compared to 2.0, however the concept is still the same.

In Moodle 2.5.x, there are 11 database tables that are related to SCORM:

mdl_scorm: Include id, course, name, scormtype, reference, intro, introformat, version, maxgrade, grademethod, etc.

mdl_scorm_aicc_session: This is a new table that did not exist in Moodle 2.0.x. Include id, userid, scormid, hacpsession, scoid, scormmode, scormstatus, attempt, lessonstatus, sessiontime, timecreated, timemodified.

mdl_scorm_scoes: has id, scorm, manifest, organization, parent, identifier, launch, etc.

mdl_scorm_scoes_track: has id, userid, scormid, scoid, attempt, element, value, timemodified.

==> For most developers you probably would be interested in this table.

@@ Line 1: / Line 1: @@
-{{Scorm}}
+This page explains the files involved in displaying a SCORM package - it is mainly useful for developers.
-The names of files in the images below are a bit out of date, however the concept is still the same.
+The names of files in the images below are a slightly out of date compared to 2.0, however the concept is still the same.
 == How player works ==
@@ Line 13: / Line 14: @@
 [[Image:Scorm view.png]]
+==SCORM Database Tables==
+In Moodle 2.5.x, there are 11 database tables that are related to SCORM:
+* mdl_scorm: Include id, course, name, scormtype, reference, intro, introformat, version, maxgrade, grademethod, etc.
+* mdl_scorm_aicc_session: This is a new table that did not exist in Moodle 2.0.x. Include id, userid, scormid, hacpsession, scoid, scormmode, scormstatus, attempt, lessonstatus, sessiontime, timecreated, timemodified.
+* mdl_scorm_scoes: has id, scorm, manifest, organization, parent, identifier, launch, etc.
+* mdl_scorm_scoes_data: has id, scoid, name, and value. That's it.
+* '''mdl_scorm_scoes_track:''' has id, userid, scormid, scoid, attempt, element, value, timemodified.
+==> For most developers you probably would be interested in this table.
+* mdl_scorm_seq_mapinfo:
+* mdl_scorm_seq_objective:
+* mdl_scorm_seq_rolluprule:
+* mdl_scorm_seq_rolluprulecond:
+* mdl_scorm_seq_rulecond:
+* mdl_scorm_seq_ruleconds:
 [[Category:SCORM]]