New answers tagged foreign-key
0
votes
How to handle the deletion of records with "shared ownership"?
I think I agree with @Charlieface
In a real world scenario (and from my personal experience) you can easily delete when thy are single tenant but it gets messy in a multi tenant scenario.
And in my ...
- 1,629
2
votes
Issues with Self-Referencing Foreign Key in SQLite
Your code is correct, but as Alexander Patrov explained in the comments, you have to enable foreing key constraints each time you connect to the database.
Dbfiddle
- 1,671
Top 50 recent answers are included