Taksi xizmati

Haydovchilar

• idint
• first_namevarchar(40)
• last_namevarchar(40)
• phonevarchar(16)
• birth_datedate
• joined_atdate
• ratingdecimal(3,2) ?
• is_activebool

Mashinalar

• idint
• driver_idint
• brandvarchar(20)
• modelvarchar(20)
• platevarchar(12)
• yearint
• colorvarchar(12)
• tariff_idint

driver_id → drivers.idtariff_id → tariffs.id

Tariflar

• idint
• namevarchar(20)
• base_faredecimal(10,2)
• per_kmdecimal(10,2)

Yo‘lovchilar

• idint
• first_namevarchar(40)
• last_namevarchar(40)
• phonevarchar(16)
• registered_atdate

Safarlar

• idint
• rider_idint
• driver_idint
• car_idint
• tariff_idint
• pickupvarchar(20)
• dropoffvarchar(20)
• requested_atdatetime
• started_atdatetime ?
• finished_atdatetime ?
• distance_kmdecimal(5,1) ?
• faredecimal(10,2) ?
• statusvarchar(10)

rider_id → riders.iddriver_id → drivers.idcar_id → cars.idtariff_id → tariffs.id

To‘lovlar

• idint
• trip_idint
• methodvarchar(8)
• amountdecimal(10,2)
• tipdecimal(10,2)
• paid_atdatetime

trip_id → trips.id