Stratus LogisticsLogistics · Courier & Freight

Database schema

The 14 core tables behind every Stratus Logistics operation.

users

482 rows
  • ★ iduuid
  • emailtext
  • nametext
  • roleuser_role
  • phonetext
  • created_attimestamptz

customers

412 rows
  • ★ iduuid → users.id
  • loyalty_tierloyalty_tier
  • delivery_countint

drivers

142 rows
  • ★ iduuid → users.id
  • vehicle_iduuid → vehicles.id
  • ratingnumeric
  • license_verifiedbool
  • statusdriver_status

freight_drivers

28 rows
  • ★ iduuid → users.id
  • vehicle_iduuid → vehicles.id
  • cdl_verifiedbool
  • capacity_kgint

vehicles

188 rows
  • ★ iduuid
  • typevehicle_type
  • platetext
  • owner_iduuid → users.id

deliveries

18,420 rows
  • ★ iduuid
  • tracking_codetext
  • customer_iduuid → customers.id
  • driver_iduuid? → drivers.id
  • serviceservice_type
  • statusdelivery_status
  • pickup_iduuid → addresses.id
  • dropoff_iduuid → addresses.id
  • feenumeric

freight_jobs

1,240 rows
  • ★ iduuid
  • manifest_codetext
  • customer_iduuid → customers.id
  • freight_driver_iduuid → freight_drivers.id
  • weight_kgnumeric
  • volume_m3numeric
  • feenumeric

delivery_tracking

184,000 rows
  • ★ iduuid
  • delivery_iduuid → deliveries.id
  • latnumeric
  • lngnumeric
  • tstimestamptz

payments

17,820 rows
  • ★ iduuid
  • customer_iduuid → customers.id
  • amountnumeric
  • methodpayment_method
  • statuspayment_status

payouts

2,480 rows
  • ★ iduuid
  • driver_iduuid → users.id
  • amountnumeric
  • statuspayout_status
  • paid_attimestamptz?

support_tickets

1,180 rows
  • ★ iduuid
  • customer_iduuid → customers.id
  • categoryticket_category
  • statusticket_status
  • priorityticket_priority

notifications

84,200 rows
  • ★ iduuid
  • user_iduuid → users.id
  • channelchannel
  • titletext
  • readbool

ratings

14,820 rows
  • ★ iduuid
  • delivery_iduuid → deliveries.id
  • starsint
  • commenttext?

pricing_zones

14 rows
  • ★ iduuid
  • parishparish
  • base_ratenumeric
  • per_kmnumeric
  • surge_factornumeric