List:General Discussion« Previous MessageNext Message »
From:Dan Rossi Date:April 4 2003 2:01am
Subject:RE: table structure design
View as plain text  
i cant seem to access the server times out :|

http://www.research.att.com/sw/tools/graphviz/download.html

-----Original Message-----
From: Nicholas [mailto:nicholas@stripped]On Behalf Of
Nicholas Spagnoletti
Sent: Friday, April 04, 2003 1:28 AM
To: mysql@stripped
Subject: Re: table structure design


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" <daniel.rossi@stripped>
> To: <mysql@stripped>
> 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/mysql?unsub=1
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1

Thread
table structure design(Daniel Rossi)3 Apr
  • Re: table structure designEMS HiTech3 Apr
  • Re: table structure designCal Evans3 Apr
    • Re: table structure designNicholas Spagnoletti3 Apr
      • RE: table structure designDan Rossi4 Apr