Get DB Schema Setup

[maclover7]

Need to plan out how to store data in the DB. Must be done before anything else

[eric-johnson]

Any new thoughts on this?

• Busses (or Trips, Routes)
  • passenger_limit
  • has_many :passengers
• Passengers
  • name

Is this an agreeable first step? As you said, it's hard to do anything else without this.

[maclover7]

Thanks for this! I think we're going to need a join/intermediary table between trips and passengers. (In case a user wants to on more than one trip) How does this look:

• Trip
  • description:text
  • name:string
  • passenger_limit:integer
  • belongs_to :host, class_name: User
  • has_many :reservations
  • has_many :users, through: :reservations
• Reservation
  • trip_id:integer
  • user_id:integer
  • belongs_to :trip
  • belongs_to :user
• User
  • name:string
  • has_many :reservations
  • has_many :trips, through: :reservations
  • has_many :trips_organized, foreign_key: :host_id, class_name: Trip

[eric-johnson]

We're also going to have organizers/hosts. That would probably be just a host attribute on each trip.

[maclover7]

updated schema comment above

[jasnow]

@maclover7 - Is this issue done?