Events and Bookings

Events

• Similarly to tutor, "tutor" users may also create "Event events"
• Event events are sessions that can handle a classroom size number of children
• Registration (booking) will be handled through the system and customers or non-customers will be able to register their children. Customers will be fast tracked through the process, while customers will need to register through a full customer signup (they will be registered and signed up at the same time).
• Event events will indicate name, dates and times, description, type of event, materials needed, spots available etc.
• Createable by Tutors and Admins, modifiable by the tutor that made it or an admin

Data

• Events have many bookings
• Events have many dates
• Events have many images

column	type
id	PK (int)
name	varchar(255)
description	TEXT
spots_available	integer, default = 3
subject_id	FK
type	varchar(255) [ tutor or event event ]
materials_needed	TEXT
address_id	FK
price	DECIMAL(10,2)
tax_rate	DECIMAL(10,3)

Shopify may have free and open source money handlers in Ruby.

---

Booking

• A booking is a link between "customer", "event", "tutor", "child"
• It is simply a join table

Data

• Booking has one child, one tutor, one event, one customer

column	type
id	PK (int)
customer_id	FK
child_id	FK
tutor_id	FK
event_id	FK