We have a section of database that for housekeeping and performance reasons doesn’t actually have foreign key constraints between the tables.
I’ve reverse-engineered the model from our database, and for the purposes of our schema diagrams put in foreign keys that don’t really exist on the database to represent the relationships between the tables.
The problem is that when I use the model update to update our diagrams it picks out these keys every time and I have to manually untick them to make sure they don’t get deleted.
Does anyone know if there is any way I can make Toad Data Modeler treat these as ‘virtual’ foreign keys that should be ignored when I use Model Update? At the moment the closest thing I can see is to draw a Line between the two tables, but that doesn’t have the all-important crows feet.
Thanks for any advice