05.05.2016, 11:00
Quote:
I'm wondering whether you linked them right because your description is kind of vague. Next to the auto-incrementing id column in the child tables you should also have a column that stores the id of the parent row in the parent table.
Rows never get added automatically. That's kind of the point. If the cascade rules are set to restrict, you can't delete a user as long as they still have toys or weapons. You must remove everything belonging to that user from those tables first before you can delete the user himself. If the cascade rules are set to, well, cascade then everything belonging to that user in the child tables will automatically be wiped if the user is deleted. |
So, can you explain me that "ID" type next to the A/I ? I don't really get that