RE: [PHP-DB] FW: db design - which is better
| From: | mayo | Date: | Sat, 07 Feb 2004 22:45:07 +0000 |
| Subject: | RE: [PHP-DB] FW: db design - which is better | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-32846@lists.php.net to get a copy of this message | ||
Thanks,
There just seems to be times when non-normalized table structures are easier
to work with. A few hundred to a few thousand records, maybe 20 fields,
rarely adding another field.
I wonder sometimes whether it make sense to put everything in one table
instead of using joins.
yours, putting-his-foot-in-his-mouth,
Gil
> -----Original Message-----
> From: Ignatius Reilly [mailto:ignatius.reilly@free.fr]
> Sent: Saturday, February 07, 2004 5:33 PM
> To: mayo; php-db
> Subject: Re: [PHP-DB] FW: db design - which is better
>
>
> Use the second design. SQL 101 / 1st normal form.
> _________________________
> ----- Original Message -----
> From: "mayo" <mayo@nycinteractive.com>
> To: "php-db" <php-db@lists.php.net>
> Sent: Saturday, February 07, 2004 23:19
> Subject: [PHP-DB] FW: db design - which is better
>
>
> >
> >
> > -----Original Message-----
> > From: Gilbert Midonnet [mailto:glm@glmdesigns.com]
> > Sent: Saturday, February 07, 2004 5:09 PM
> > To: php-db
> > Subject: db design - which is better
> >
> >
> > I have a client who has hundreds of articles. Each article can
> be seen by
> > one or more permission groups.
> >
> > I have questions regarding setting up the an article_display table.
> >
> > The easiest table to read and to conceptualize would list the
> articles and
> > use a boolean for each of the permission groups (let's call the PGs for
> this
> > example).
> >
> > (articleNameID refers back to the article table)
> >
> > articleNameID---PG1---PG2---PG3---PG4---PG5
> > 1001-------------1-----0-----0-----0-----0
> > 1002-------------1-----1-----0-----0-----0
> > 1003-------------0-----0-----1-----0-----0
> >
> >
> > Or should the table set up be:
> >
> > articleNameID--PG
> > 1001------------1
> > 1002------------1
> > 1002------------2
> > 1003------------3
> >
> > etc...
> >
> > gil
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
> >
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>