I’m new to Data Modeler.
I recently started a new job and their database doesn’t have any physical relationships among the tables and they don’t want to add them. For my own reference I’d like to document something to show the relationships among the tables. I’ve reverse engineered some of the tables into a model, but when I try to create relationships it just creates the pk in the child table from the parent table. In my case product table has ID as primary key and child table field I want to link to is called PRODUCT_ID. Logically linked columns are not named the same. Will this tool allow me to do this for diagramming purposes or should I look elsewhere.