title: Event management schema design
body: <p>I am designing an event management system (to be used for personal events like bdays etc + corporate events + campaign events). The relationships are Event belongs to a Campaign, Events have days and days have sessions. At the same time each of these: (Campaign, Event, Day, Session) can have the same attributes like Budget, Goal, Mission, etc. So should these be stored in their own tables like an event_mission, event_goal, event_budget table or should they be thrown in as columns in the (event, campaing, days, session) tables?</p>
  
  <p>There are other attributes like: Location, Area within a location, People invited, people attending, etc that fit into each of the above, so again I can combine them into their own tables for all like event_loc, campaing_loc, days_loc, session_loc or break them up at each level with one location table and have flags for each level.</p>
  
  <p>Ofcourse this is only applicable for promotional events not personal events.</p>