everactive — 2010-02-16T23:41:35-05:00 — #1
I have a PHP script with many restricted areas. In each of these areas I have a function that checks if the user have access to the current area by checking the "usergroup" table. That problem is I have over 100 columns now so I'm not sure if that's a correct database design.
Please advise. Thanks.
r937 — 2010-02-16T23:45:31-05:00 — #2
the "current areas" should each have a separate row in a one-to-many table
having 100 columns is a pretty sure sign that the table isn't in first normal form
everactive — 2010-02-17T00:04:10-05:00 — #3
I'm a little bit lost. Each user may belong to more than one usergroup so my current structure looks like this:
How should it look in your way?
r937 — 2010-02-17T00:10:51-05:00 — #4
everactive — 2010-02-17T00:49:11-05:00 — #5
Thanks, I'll try that