Here is what I would like to accomplish:
Create an event database system whereby someone(user) can register as a host of a predefined(by the website) event type with event details, He/She (user above) would invite Guests to sign up for the event and the event registrant/host would be able to view/update/edit/delete any information about the guests that signed up for their respective events.
This is what I have so far with the design:
Tables:
Users (userID, userInfo)
Events( EventID, EventTypeID, UserID, EventDetails)
Guests (GuestID, userID, eventID, GuestDetails)
Event type( EventTypeID, userID, event types Details)
Please any suggestions would be very much appreciated!