New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Refactor specific database table #220

Open

Peterrahr opened this issue Dec 6, 2024 · 0 comments

Labels

Contributor

Peterrahr commented Dec 6, 2024

There are some inconsistencies in the database regarding the ER diagram/relational schema. It works but does not follow the standard/best practices.

The table mdl_livequiz_course_quiz is never populated, hence can be deleted

The following relation table should be foreign keys in existing tables:

Add a foreign key to livequiz_answers called question_id from the livequiz_questions table. Delete the relation table livequiz_questions_answers
Add a foreign key to livequiz_questions called lecturer_id from the "moodle user id" table. Delete the relation table livequiz_questions_lecturer
Add a foreign key to livequiz called lecturer_id from the "moodle user id" table. Delete the relation table livequiz_quiz_lecturer

Peterrahr added the enhancement label

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment