Page 1 of 1

phpMyAdmin relation view?

Posted: Thu Oct 26, 2006 7:55 pm
by alex.barylski
I just noticed that little relationship icon, click on it and associated a couple tables...I assume PMA saves this information and it's not an intergral part of mySQL...which doesn't yet support foriegn keys???

Anyways...ignore the above...how can I use this feature to generate a schema which demonstrates table relationships??? UML diagram or other???

I need to print off about 20 tables and how their related cuz I'm starting to loose track :P hopefully in a *nice* UML diagram not tabular displays, etc...

Anyone know how? I'd greatly appreciate it :)

Posted: Thu Oct 26, 2006 8:40 pm
by feyd
MySQL has supported foreign keys for quite some time.

Posted: Thu Oct 26, 2006 8:47 pm
by Luke
yea innodb supports foreign keys man

Posted: Thu Oct 26, 2006 9:34 pm
by alex.barylski
:lol:

I had a hunch MySQL likely supported foriegn keys now...it's why I asked for people to ignore that fact :P

Anyways, that isn't the point of this thread...stay on topic you two ;)

Is there a tool which will render table relationships in a class hierarchy type fashion? What is the meaning of that relation view feature of PMA???

Cheers :)

Posted: Thu Oct 26, 2006 9:36 pm
by nickvd
I use DBDesigner 4 to create the tables.. it lets you draw all the relations, and will create the FK's for you... Don't know if it will read existing databases and create the layout for you though...

Posted: Thu Oct 26, 2006 9:42 pm
by alex.barylski
I'll look into it :)

Thanks :)