There were no foreign key constraints at the database level - the application must have been holding and enforcing the relevant constraints. A bit of a pain wh

There were no foreign key constraints at the database level - the application must have been holding and enforcing the relevant constraints. A bit of a pain when you are looking at the SQL database trying to understand how it is structured so you can extract data in a meaningful way.