FW: db design - which is better
| From: | mayo | Date: | Sat, 07 Feb 2004 22:19:55 +0000 |
| Subject: | FW: db design - which is better | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-32843@lists.php.net to get a copy of this message | ||
-----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