All Questions
Tagged with cascade referential-integrity
3 questions
4
votes
1
answer
2k
views
Complex Delete Cascade Including Self-Referencing Table
Above is a diagram of my data structure. It represents a hierarchy which can contain three different types of "elements": "A"s, "B"s and "C"s. The relationships show the delete cascade behavior I ...
- 143
3
votes
0
answers
164
views
Visualize the effects of a cascading delete or update?
In MySQL, I'm working with a database that has integrity constraints on foreign keys (nothing overly special here).
Is there a method to somehow visualize the effects of a cascading delete or update?
...
- 131
2
votes
1
answer
11k
views
ON DELETE CASCADE not working
Trying to implement a simple user follower system in MySQL, using a junction table:
CREATE TABLE users (
id int NOT NULL AUTO_INCREMENT,
email varchar(255) NOT NULL,
username varchar(25) ...
- 21