1. Closed Tasks
  2. Details

#114 - Update SQL Tables to allow for cascading deletionClosed

This will allow when the primary entity is deleted it will call delete it from the tables on the foreign tables automagically

  • This will save us from writing additional code upon delete
  • Enhancing Referential Integrity
  • Way better performance
  • Allow for better consistency across the app
Milestone:
25.03 - Stable - Due: 2025-03-20
Assigned To: =^_^=Johnny
Created Date: 2025-03-13 12:53:13
Closed Date: 2025-03-15 17:11:02
Discussion Link:

Comments 1

[o_O] Johnny Commented on 2025-03-15 17:11:02

Updated all many-to-many relationship tables to utilize foreign keys with cascading deletes. Additionally, removed the PHP logic that was previously used to delete the entities.

Note: This change applies primarily to the many-to-many relationship tables