Database schema 1.6
From Dokeos
The current Dokeos databases are made of four databases. The main database, generally called dokeos_main, the course database, generally called dokeos_name_of_the_course, the scorm database and the tracking database.
Contents |
The main database
The main database contains the general information, that is the users data, courses data and all their relations. Media:Main.png
The course database
Depending on the install mode you selected, this can contain all the courses tables or just the tables of one course. The following schema shows the one-database-per-course mode. The schema is not perfect yet, in the way it doesn't represent correctly the links between resources (in the Dokeos sense). Media:Course.png
The tracking database
This database is used for the tracking of events, as well as the scoring of non-scorm tests. Media:Stats.png
The SCORM database
This database is reserved for the SCORM-related data (courses and tests imported in the SCORM format). There is no graphic at the moment, but the database is only composed of 3 small tables. Media:Scorm.png
The new user database
This database keeps information applicable directly to users, not related to courses. Media:User.png
Schemas sources
This schemas sources can be freely downloaded in Dia format (free open-source application to draw diagrams, having a lot more uses in the developer community) in the Dokeos website download directory, using the following links:
These schemas are under the GNU/GPL 2 license.
