database schema for event calendar

[venkat0904]

Hi all,

1) Users can belong to a specific group wherein when the group moderator publishes an event, its visible to all the members of group.

2) A normal user can publish event in his own calendar, to make that event visible to all users in group, the group moderator needs to approve it.

3) While adding an event, a user can select from a list of available resources which gets booked for event's duration and no one else can publish an event using those resources at the same time.

4) Also when a moderator adds a member to his group, the member needs to approve whether he agrees to be in that specific group. Only after he agrees, he can view that group's events.

5) A user can belong to more than one group.

if anyone has any suggestions... u r most welcome !!!
m a php developer and have absolutely no experience in DB design..
help me out guys..

[Gilette]

1) Users can belong to a specific group wherein when the group moderator publishes an event, its visible to all the members of group.

R1) What I can see, this is a list of users and a list of groups. Each user have a name, a email address and a membership of a group, Each group has a name and a moderator. Every row in the user table have then this columns: Id, name, email, group. The group column is probably linked to the group Id column and that makes this column a foreign key. Every row in the group table have then this columns: Id, Name, Moderator; The moderator will probably be linked to the Id of a user in the user table which makes this column a foreign key.

When searching for group members, u can use the 'where' statement to find all of them. Also when searching a moderator for a specific group, u can use the 'where' statement.

Hope this helps you to make the rest of the tables easy to make.