Re: FW: db design - which is better
| From: | Ignatius Reilly | Date: | Sat, 07 Feb 2004 22:32:42 +0000 |
| Subject: | Re: FW: db design - which is better | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-32844@lists.php.net to get a copy of this message | ||
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
>
>