-----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
