Skip to content
DBML templates

DBML — ride-hailing schema

Riders, drivers, rides, payments.

Template previewDBML
vehicles.driver_id > drivers.idrides.rider_id > riders.idrides.driver_id > drivers.idpayments.ride_id > rides.idridersiduuidphonevarcharcreated_attimestampdriversiduuidphonevarcharstatusvarcharvehiclesiduuiddriver_iduuidplatevarcharridesiduuidrider_iduuiddriver_iduuidfare_centsintstatusvarcharpaymentsiduuidride_iduuidmethodvarcharstatusvarchar

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 }