I'm a newbie at Database Designing. What I want to do is perform several actions at once.
I have a main
users table which holds all the data for a user at a website. Then I have a
primary key as the
user_id in this table. This
user_id is also the referred in various other tables.
So, what I want to do is connect all those table data to the main table so that when the main user is deleted from the
users table then all the data related to that user is also deleted. How can I do that?
I know there is a function of foreign keys somewhere but I'm a really amateur programmer.