Reverse DATABASE (MySQL) - no relationship on diagram

General Questions/Discussions
1

I try to use DB Visual Architect to build Relationship Diagram from existing MySQL DB. At the end of the process I get whole tables but no relationship between them. Please look to attachment - bk_model (oryginal model from DB DESIGNER 4), bkvisualparadigm (reverse model with no relationships).

What is wrong?

bkvisualparadigm.jpg746×746 125 KB

bkvisualparadigm.jpg
bk_model.png1037×1248 89.5 KB

bk_model.png

2

Hi user,

This is a known issue. The problem is due to MySQL do not store the FK relationships by default. Unless your database was created using InnoDB or MyISAM, no relationship will be created during reverse.

Best regards,
Jick