Basic info for both riders and drivers
| Field | Type | Notes |
|---|---|---|
| Name | Text | |
| 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 |
(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 |
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 |
| 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" |
| 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 |