RE: [Phplib-users] Re: [phpslash-users] Hello -- I could use some help

[Rob H. <rob...@ws...>]

  There is no way in MySQL to do it automagicly because there is no foreign
key support.  Even if they didn't actually enforce data integrity rules, it
would be nice to have them just because of the modeling.
  That said, I do most of my modeling for simple stuff in *choke* Visio.  It
will read the table definition through odbc and then you can drop the
relationships in failry easily.

Thanks,
Rob Hutton
Web Safe
www.wsafe.com

> -----Original Message-----
> From: php...@li...
> [mailto:php...@li...]On Behalf Of Joe
> Stewart
> Sent: Thursday, November 07, 2002 10:59 AM
> To: 'phplib-users'
> Subject: [Phplib-users] Re: [phpslash-users] Hello -- I could use some
> help
>
>
> Hey, can anyone suggest a way to model the database relationships for
> Kareem?
>
> thanks,
>
> Joe
>
> On Thu, Nov 07, 2002 at 09:08:20AM -0500, Kareem Lawrence wrote:
> > Joe,
> >
> > Since you can't recommend a product like ERwin that will allow
> me to view
> > the database schema. Can you recommend a method by which I can
> determine the
> > relationships between the tables in the database? This would be
> very useful
> > to me for any additions I may want or need to make. Using this
> as a teaching
> > tool for myself. Do you think you could help?
> >
> > Kareem
> >
> > -----Original Message-----
> > From: Joe Stewart [mailto:jo...@be...]On Behalf Of Joe Stewart
> > Sent: Tuesday, November 05, 2002 12:24 PM
> > To: Kareem Lawrence
> > Subject: Re: [phpslash-users] Hello -- I could use some help
> >
> >
> > On Mon, Nov 04, 2002 at 12:30:44PM -0500, Kareem Lawrence wrote:
> > > Joe,
> > >
> > snip!
> >
> > > One very important thing that PHPSlash has
> > > over it is the ability to associate a single story to
> multiple areas of a
> > > web site. If brief overview of underlying db of PHPSlash it would seem
> > that
> > > what it's missing is a collections table that aggregates the
> associations.
> >
> > I may be misunderstanding but...
> >
> > While integrity is maintained for the associations, I don't think all
> > pageviews use the same associations.
> >
> > > What would be really useful to me is to get a data modeling
> product like
> > > ERwin to view these relationships more clearly so that I don't have to
> > rely
> > > on my (usually faulty) suppositions. Can you recommend something?
> > >
> >
> > Sorry. no.
> >
> > later,
> >
> > Joe
> >
> > > Kareem
> > >
>
>
> -------------------------------------------------------
> This sf.net email is sponsored by: See the NEW Palm
> Tungsten T handheld. Power & Color in a compact size!
> http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0001en
> _______________________________________________
> Phplib-users mailing list
> Php...@li...
> https://lists.sourceforge.net/lists/listinfo/phplib-users
>
>