Story #18 Add Preset Events table to Database | Technical Documentation - cseseniordesign/reservations GitHub Wiki

Technical Documentation

Database

• Changes within the database:
  • Added new table preset_events to hold preset events. It contains the following fields.
    • id INT(11) NOT NULL,
    • event_name VARCHAR(255) NULL,
    • description VARCHAR(255) NULL,
    • event_type_id INT(11) NULL,
    • max_signups INT(11) NULL,
    • duration INT(11) NULL, (Integer is in minutes, a value of 60 would be an hour-long duration.)
  • Added join table between preset_events and resources called preset_events_has_resources to have access between the tables