For tables that have rows inserted during Moodle installation (via db/install.php), the SchemaSpy schema page for that table includes a "View install data" link. The link points to a generated HTML page (located in tables/data/<tablename>.html under the SchemaSpy output directory) that lists every row inserted at install time. Each data page includes a back-link to its parent schema table page.
Tables with install data pages (54):
assign_allocated_markerOne or more teachers allocated to mark individual submissions
| column | type | nullable |
|---|---|---|
| id | BIGINT(19) | NOT NULL |
| student | BIGINT(19) | NOT NULL |
| assignment | BIGINT(19) | NOT NULL |
| marker | BIGINT(19) | NOT NULL |
assign_markMarks from multiple markers for a single submission
| column | type | nullable |
|---|---|---|
| id | BIGINT(19) | NOT NULL |
| assignment | BIGINT(19) | NOT NULL |
| gradeid | BIGINT(19) | NOT NULL |
| timecreated | BIGINT(19) | NOT NULL |
| timemodified | BIGINT(19) | NOT NULL |
| marker | BIGINT(19) | NOT NULL |
| mark | DECIMAL(10,5) | NULL |
| workflowstate | VARCHAR(20) | NULL |
These two tables together support multi-marker assignment grading introduced in 5.2.
dataAll database activities (mod_data)
| column | type | nullable |
|---|---|---|
| id | BIGINT(19) | NOT NULL |
| course | BIGINT(19) | NOT NULL |
| name | VARCHAR(1333) | NOT NULL |
| intro | LONGTEXT | NOT NULL |
| introformat | SMALLINT(5) | NOT NULL |
| comments | SMALLINT(5) | NOT NULL |
| timeavailablefrom | BIGINT(19) | NOT NULL |
| timeavailableto | BIGINT(19) | NOT NULL |
| timeviewfrom | BIGINT(19) | NOT NULL |
| timeviewto | BIGINT(19) | NOT NULL |
| requiredentries | INT(10) | NOT NULL |
| requiredentriestoview | INT(10) | NOT NULL |
| maxentries | INT(10) | NOT NULL |
| rssarticles | SMALLINT(5) | NOT NULL |
| singletemplate | LONGTEXT | NULL |
| listtemplate | LONGTEXT | NULL |
| listtemplateheader | LONGTEXT | NULL |
| listtemplatefooter | LONGTEXT | NULL |
| addtemplate | LONGTEXT | NULL |
| rsstemplate | LONGTEXT | NULL |
| rsstitletemplate | LONGTEXT | NULL |
| csstemplate | LONGTEXT | NULL |
| jstemplate | LONGTEXT | NULL |
| asearchtemplate | LONGTEXT | NULL |
| approval | SMALLINT(5) | NOT NULL |
| manageapproved | SMALLINT(5) | NOT NULL |
| scale | BIGINT(19) | NOT NULL |
| assessed | BIGINT(19) | NOT NULL |
| assesstimestart | BIGINT(19) | NOT NULL |
| assesstimefinish | BIGINT(19) | NOT NULL |
| defaultsort | BIGINT(19) | NOT NULL |
| defaultsortdir | SMALLINT(5) | NOT NULL |
| editany | SMALLINT(5) | NOT NULL |
| notification | BIGINT(19) | NOT NULL |
| timemodified | BIGINT(19) | NOT NULL |
| config | LONGTEXT | NULL |
| completionentries | BIGINT(19) | NULL |
moodlenet_share_progressRecords MoodleNet share progress — MoodleNet integration dropped in 5.2.
| column | type | nullable |
|---|---|---|
| id | BIGINT(19) | NOT NULL |
| type | TINYINT(3) | NOT NULL |
| courseid | BIGINT(19) | NOT NULL |
| cmid | BIGINT(19) | NULL |
| userid | BIGINT(19) | NOT NULL |
| timecreated | BIGINT(19) | NOT NULL |
| resourceurl | VARCHAR(255) | NULL |
| status | TINYINT(3) | NULL |
Total tables: 494 (5.1) → 496 (5.2)