Hello Everybody

This my first post. I'm totally new to the world of databases. I'm still learning, and I would like to create a database for a site of local events(sport music). The idea is kind of stupid, i would just want to know if it's technically correct.

First i have the Table of members :

memberID username password signupDate email country City ID


Then the Tables of the cites : ( i know it is kind of useless)

CityID nameOfCity country



Then the table of all the events:

nameOfEvent EventID cityID restricted(bool) TypeOfTheEvent


Then the table for each member :

UserID eventID Accepted (bool)


And finally the table for each event:

EventId UserID accepted (bool) InviteOthers (bool) Rating of the event


So as you see, I want to create a table for eache member, and for each event. I don't know if it's a good thing...
Please, would you help me correct this database, or just give me some advices?

Thanks in avance

it isn't

all you need is one table for member events, that will have two columns as the primary key -- memberid and eventid

also, your cities table is, as you guessed, kind of useless

Thanks, I'm going to correct that.