DBML — ride-hailing schema
Riders, drivers, rides, payments.
Make it your own.
Table riders { id uuid [pk]; phone varchar; created_at timestamp }
Table drivers { id uuid [pk]; phone varchar; status varchar }
Table vehicles { id uuid [pk]; driver_id uuid [ref: > drivers.id]; plate varchar }
Table rides { id uuid [pk]; rider_id uuid [ref: > riders.id]; driver_id uuid [ref: > drivers.id]; fare_cents int; status varchar }
Table payments { id uuid [pk]; ride_id uuid [ref: > rides.id]; method varchar; status varchar }