Use the second design. SQL 101 / 1st normal form. _________________________ ----- Original Message ----- From: "mayo" <mayo@xxxxxxxxxxxxxxxxxx> To: "php-db" <php-db@xxxxxxxxxxxxx> Sent: Saturday, February 07, 2004 23:19 Subject: FW: db design - which is better > > > -----Original Message----- > From: Gilbert Midonnet [mailto:glm@xxxxxxxxxxxxxx] > 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
