When creating tables or adding columns permanent go to /Shared/SQL/init_db.sql
and follow the current syntax when adding your table/column. When you are done go to /install/
and run install.php
for the changes to take effect.
When adding or editing testdata go to /install/SQL/testdata.sql
and keep in mind to keep the structure in the code. When you are done go to /install/
and run install.php
for the changes to take effect.
An entry in the announcement table is created when a teacher creates an announcement. There will be one entry in the table for each student that gets the announcement.
"Dugga" entries in the "Webbprogrammering" course. 2 entries per dugga, 1 txt entry and one other for the dugga type (html, php or js file). (NOT IMPLEMENTED YET, NOT FUNCTIONAL.)
The class table stores all the programs that are available in the school and is stored alongside a responsible teacher for that class.
Code Example contains a list of the code examples for a version of a course in the database. Version of sections and examples corresponds roughly to year or semester that the course was given.
In this table every course that is available is stored, however there are some courses that has visibility '0' and those courses are only visible for the teachers. The course table contains the most essential information relating to study courses in the database.
This table represents a many-to-many relation between courses, to illustrate pre-requirements for courses.
When a user tries to log in and fails to enter the correct password an entry is created in the eventlog table.
An entry in this table allow file locations to be related to specific courses. For example, if an instructor wants to give students a link to a file that they should be able to download from the course page.
All groups that exists are stored in this table. Students needing to team up on a cooperative dugga are assigned to a group (This is done in the user_group table).
This is a view that pulls the top 10 fastest quiz finishing students and lists them.
improw contains a list of the important rows for a certain example (NOT IMPLEMENT YET, NOT FUNCTIONAL BECAUSE IT USES THE box TABLE).
impwordlist contains a list of important words for a certain code example (NOT IMPLEMENT YET, NOT FUNCTIONAL BECAUSE IT USES THE box TABLE).
This table is not used.
The listentries table contains the list of dugga's, headers, etc. in a course. Everything that is listed in a dugga is stored in this table.
Opponents table used to save opponents for seminars.
This table is not used.
This table is not used right now. However, it stores results from a part of a course. Might need a rework.
This table is not used.
This table represents a many-to-many relation between class and course tables.
The quiz table contains everything related to a dugga, and connects the dugga to a specific .js template file. It does not save answers, it only loads the dugga how it is supposed to look like.
This table is not used.
The settings table is used for setting the MOTD in courseed.php. This MOTD is currently hidden but can still be set.
This table is not used.
A view that selects elements from the partresult and subparts tables.
The table that stores the link to the uploaded file that a student submits on a dugga where you upload a file.
Not in use at the moment. However, it stores the different subparts of each course.
This table is not used, there is no way to insert and all the entries in the table are files that do no exist.
Used for timesheet duggas.
Stores all the users that exists in the system.
Stores all the duggas that has been saved in the system. That is, the answers that a student has entered is stored here.
This table represents a many-to-many relation between users and courses. That is, a tuple in this table joins a user with a course.
Represents a many-to-many relation between users and groups.
This table is not used.
Stores all users that have signed up for push notifications.
An entry in the variant table is used to add questions to quiz tests.
Stores the different versions of a course for different years.
Stores all the keywords that are used in a specific language.
Used to categorize the words from the word table into different languages.