Hi
About Entity Relationship Diagrams: I use Graphviz to generate ERD's on
the fly, from the database. Graphviz is very cool:
http://www.research.att.com/sw/tools/graphviz/
Graphviz draws graphs from files written in its language (called 'dot')
Your PHP script (or language of choice) needs to get the tables and
fields from MySQL, take your naming conventions etc. into account, and
output a dot file that will look like something like this in its
simplest form:
<snip>
digraph schema {
user [shape=record, label="ID|name|surname"];
user -> user_group;
user_group [shape=record; label="ID|groupname"];
}
</snip>
Pipe that to dotty (part of the graphviz suite) and it will display a
graph with one block called user (and its fields) and one block called
user_group (and its fields) and a line joining them.
So all you need to do is write your own script to output all your tables
and their relationships and dotty will draw it nicely for you.
On Thu, 2003-04-03 at 16:12, Cal Evans wrote:
> Lots of them. None cheap. What ever you do, steer clear of the one at
> www.thekompany.com. It's a piece of crap. I bought a version and then
> foolishly bought an upgrade thinking it would be better. it's not and the
> primary programmer for the project is very arrogant on the mailing list
> setup for support.
>
> ERWin is a great tool but it does not support MySQL directly. (You could use
> ODBC to reverse engineer a database though) The same with ERStudio from
> Embarcadero (sp?) Great tool, expensive though.
>
> =C=
>
> ----- Original Message -----
> From: "Daniel Rossi" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Thursday, April 03, 2003 12:37 AM
> Subject: table structure design
>
>
> is there any table structure design program in a graphical layout for
> windows available ? i have tables and fields on paper but would like a way
> to be able to lay them out on a screen and show which table joins to what
> and what keys it uses let me know thanks
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
