How to reverse engineer relationships on ERD

General Questions/Discussions
1

I just started using VP. I am trying to reverse engineer a MySQL database into an ERD. I have got the tables into the diagram, but had to create all the relationships manually. Can VP create these automatically, or provide some help? E.g. if I have a table with the foreign key RoleID, and I have a table called Roles with the PK RoleID, should it not be easy for a piece of software to deduce that there is a relationship between the two?

Thanks - Rowan

2

Dear Rowan,

The relationship between entities are automatically reversed from the FK constraint in DB schema. May I know did your DB schema having FK constraints defined? Look forward to hearing from you.

Best regards,
Rain Wong