Improve foreign key relations in database

tl-its-umich-edu / my-learning-analytics

My Learning Analytics (MyLA)

Apache License 2.0

36 stars 39 forks source link

Improve foreign key relations in database #1021

Open jonespm opened 4 years ago

jonespm commented 4 years ago

Thank you for contributing to this project!

Describe your problem or feature you'd like added

We should improve the foreign key relations in this project. Some of the tables are linked and more are able to be linked through foreign keys, however.

They are set to delete/update RESTRICT. Some of these should just be CASCADE like course_view_options->course and resource_access->course.
Some tables aren't linked, like resource_access->user

There's probably more that can be done here.

jennlove-um commented 1 year ago

This needs to be reviewed to see if it's been addressed in other work. @ssciolla Has the work you've done in the last few releases fixed this?