devsoc-unsw / chaos

The eventual repository for the CHAOS Hiring and Offers System - used to manage sending and receiving of applications, interviews and results.
https://chaos.csesoc.app
Other
24 stars 5 forks source link

Fix overuse of `ON DELETE CASCADE` #520

Open KavikaPalletenne opened 1 month ago

KavikaPalletenne commented 1 month ago

We can't always CASCADE the deletes, because we want to keep things even if user accounts are deleted. If user is deleted, we put in a dummy id of -1 for example.

KavikaPalletenne commented 1 month ago

This also requires FE and all Postgres JOINs to handle the non-existing user case