phpMyAdmin relation view?

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
alex.barylski
DevNet Evangelist
Posts: 6267
Joined: Tue Dec 21, 2004 5:00 pm
Location: Winnipeg

phpMyAdmin relation view?

Post 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 :)
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

MySQL has supported foreign keys for quite some time.
User avatar
Luke
The Ninja Space Mod
Posts: 6424
Joined: Fri Aug 05, 2005 1:53 pm
Location: Paradise, CA

Post by Luke »

yea innodb supports foreign keys man
alex.barylski
DevNet Evangelist
Posts: 6267
Joined: Tue Dec 21, 2004 5:00 pm
Location: Winnipeg

Post 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 :)
nickvd
DevNet Resident
Posts: 1027
Joined: Thu Mar 10, 2005 5:27 pm
Location: Southern Ontario
Contact:

Post 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...
alex.barylski
DevNet Evangelist
Posts: 6267
Joined: Tue Dec 21, 2004 5:00 pm
Location: Winnipeg

Post by alex.barylski »

I'll look into it :)

Thanks :)
Post Reply