Haven't found any open source ERD editors out there. BUT, realized that Visio has ERD diagramming capability, out of the box. Visio seems pretty prevalent around enterprises. If you look, you might find it and can describe your data model using one of several de acto standard methofologies.
----- Original Message ----- From: "Mark Matthews" <[EMAIL PROTECTED]> To: "Keith C. Ivey" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, May 15, 2002 6:27 PM Subject: Re: Column Header/ Column Description > > ----- Original Message ----- > From: "Keith C. Ivey" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, May 15, 2002 4:54 PM > Subject: Re: Column Header/ Column Description > > > > On 15 May 2002, at 16:06, Mark Matthews wrote: > > > > > I'm interested in hearing what databases you have used that have this > > > functionality? SQL server and Oracle do not, for example. > > > > MS Access does. Also, it seems a bit inconsistent that MySQL has > > metadata (the comment) associated with each table, but has nothing > > similar for databases or columns. It's certainly not essential, but > > I've wondered about it before. > > I'm of the opinion that storing the sort of metadata you're talking about in > the database is a bad idea. I don't even think that the table comment > functionality that MySQL does have is absolutely necessary. Storing this > sort of metadata in the database seems to be counterproductive to me, > especially because it's only available if you know SQL and are working with > the database. But that's another discussion. > > I would hope that developers create table and column names that are > descriptive enough to get a general understanding of what's going on, and > that anything that wasn't self-describing is documented in a set of "release > notes" or a data dictionary. > > I'm also of the opinion that a picture is a much better tool for this sort > of thing. Unfortunately, there aren't many open-source ERD editors out > there. > > -Mark > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
