[Ilugc] mysql optimization
- From: codeshepherd@xxxxxxxxx (Deepan Chakravarthy)
- Date: Fri Jul 16 08:44:24 2010
| Each group has a groupid, each user has a uid, each group has ?group
| specific data like group_question_id etc.
\--
Does a group have many questions?
A group can have only one question.
---
| Each user can answer the group question with
| group_answer_uid. The number of group_answer_uid (s) for user is equal
| to number of groupid is he is part of.
\--
Can you rephrase the above? Do you mean that if a user P belongs to
groups A, B, then P can answer one question each in groups A and B?
You are correct. If user P belongs to group A,B, then P can answer
questions in both group A and B. (remember there is only one question
per group)
Other related posts: