On Thu, Jul 15, 2010 at 9:30 PM, Deepan Chakravarthy <[email protected]
> wrote:

>
> I need some help in creating the best possible table schema for the
> following condition.
>

My Try:
 #Users - username,userid
 #Groups - groupname,groupid
 #Usergroups - userid,groupid
 #GroupQs  - groupid, groupQid,groupQQuestion
 #UserAnss   - userid, groupQid, userAnswer

Where Users,Groups,Usergroups,GroupQs ,UserAnss are the tables and the comma
separated list in front of the table name is the columns.

As for the queries, if you are using django-orm(or any other ORM) then it
should be pretty easy.

-V-
http://twitter.com/venkasub
_______________________________________________
ILUGC Mailing List:
http://www.ae.iitm.ac.in/mailman/listinfo/ilugc

Reply via email to