Ensure relational integrity across database tables - Githubissues

harakeke-2019 / EDAMAME

EDAMAME: Enspiral Dev Academy Management of Assessment Modules Emily

1 stars 3 forks source link

Ensure relational integrity across database tables #105

Closed bryceknz closed 5 years ago

bryceknz commented 5 years ago

All foreign keys should use references in their migration to ensure data integrity.

[x] Students table needs to reference users.id and cohorts.id
[x] Assessments table needs to reference modules.id
[x] Students_Assessments table needs to reference students.id, assessments.id, and statuses.id

Note* This may affect how the migrations and seeds are run - order matters! Pay attention to this and fix any ordering errors if they arise.