I don't know if it's obvious but I'm not entirely sure how to delete joined table records? For example. I have a project which also has associated contracts, files etc in other tables. They are all linked using the project foreign key.
How do I construct a query to that I delete the actual project record in the projects table AS WELL AS the other entries in the other tables?