User Story: As a developer, I have a database to hold relevant information.

Database Design

First draft of the database which should model all associated information.

Passengers and Drivers

userStatus refers to wether a user is online or not, as well as if they are using the app as a driver or rider. carPool refers to whether a user is open to riding with other passengers. schedule refers to the school schedule of the rider and driver. available seats refers to the total amount of passengers a driver is willing to take at a time. In UniJet all users are automatically registered as passengers while it is left as an option to register as a driver.

University and Classes

This will contain information regarding which courses are offered by a specific university. It will also contain information such as the primary and secondary colors which will be leveraged in dynamically creating the look of the frontend