rlee128Original post
Rank 2: Process
When selecting what to do on delete. How do we know which direction the delete will occur? For example: Say we have a notes table and a user table. On the notes table we add a relationship to the user table as a one way relationship and the relation is many to one. Does that mean if the notes row is deleted it will delete the user row or does it mean if the user row is deleted it will delete all rows linked to the user row?
Summary
In a one-way relationship where the relation is many to one (from notes to user), deleting a notes row will not delete the user row. Deleting the user row will delete all rows linked to that user.