PHP SQL - database organisation

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

database organisation

Joja

2007-01-06, 7:10 pm

I have 5 major and 30 sub groups.
Each subgroup has cca 8 fields and each user can be in few
grups/subgroups/fields.
**********************************
e.g.
main table ( projects )
table: maingroup
table: subgroups
table: groupsList
***********************************
You can browse main,subgroups and fields.
e.g.
projects
web design
php
************************************
The problem is that the user can in multiple subgroups and fields (web
design, database design, php, ASP etc. ) and i have to organise all this.

So the question is how to make this and how to make the db optimization.

Sponsored Links