Data Types and Option sets

1. User

Basic info for both riders and drivers

Field Type Notes
Name Text
Email Email
Phone Text
User Type Text (option set: "Rider", "Driver")
Profile Photo Image Optional
Current Location Geographic address Optional (useful for real-time updates)
Rating Number Avg. of ratings received
Vehicle (for drivers) Vehicle (data type) Only if User Type = Driver
Active Trip Ride/request /Trip

2. Driver/ Vehicle

(Only for drivers)

Field Type Notes
Driver User (User type = Driver)
Make Text e.g., Toyota
Model Text
Year Number
Plate Number Text
Color Text
Photo Image Optional
Approved Yes/no
Type Car/ Trip Type option set

3. Ride Request / Trip

The main record of a trip.

Field Type Notes
Rider User (User type = Rider)
Driver User (User type = Driver, nullable at start)
Pickup Address Geographic address
Dropoff Address Geographic address
Status option set: "Requested", "Accepted", "On the way", "In Progress", "Completed", "Cancelled"
Price /Fare Number
Rider Rating Number Rating given by driver
Driver Rating Number Rating given by rider
Type Car/ Trip Type option set

4. Payment

Field Type Notes
Trip Ride Request / Trip
Amount Number
payment Status Text (option set: "Pending", "Paid", "Failed")
Payment Method Text Optional, e.g., "Card", "Cash"

5. Rating

Field Type Notes
Trip Ride Request / Trip
Linked Rider User The rider
Linked Driver User The driver
Score Number e.g., 1–5
Review Text Optional comments

6. Message (optional, for chat)