test1

Tables (9)

Untitled

    admin

    • admin_id — bigint — Primary key — NOT NULL
    • login_id — varchar(255) — NOT NULL
    • name — varchar(255) — NOT NULL
    • password — varchar(255) — NOT NULL

    driver

    • driver_id — bigint — Foreign key → user.user_id — NOT NULL
    • account_number — varchar(255)
    • bank_code — varchar(255)
    • cert_number — varchar(255) — NOT NULL
    • holder_name — varchar(255)

    location_log

    • location_id — bigint — Primary key — NOT NULL
    • created_at — datetime(6) — NOT NULL
    • driver_id — bigint — Foreign key → driver.driver_id — NOT NULL
    • shipment_id — bigint — Foreign key → shipment.shipment_id — NOT NULL
    • shipper_id — bigint — Foreign key → shipper.shipper_id — NOT NULL
    • location_data — text — NOT NULL

    notification_log

    • notification_id — bigint — Primary key — NOT NULL
    • sent_at — datetime(6) — NOT NULL
    • target_id — bigint — Foreign key → user.user_id — NOT NULL
    • extra_data — text
    • firebase_message_id — varchar(255)
    • notification_content — varchar(255) — NOT NULL
    • notification_title — varchar(255) — NOT NULL

    shipment

    • shipment_id — bigint — Primary key — NOT NULL
    • cargo_weight — double — NOT NULL
    • driver_cancel_toggle — bit(1) — NOT NULL
    • need_freeze — bit(1) — NOT NULL
    • need_refrigerate — bit(1) — NOT NULL
    • platform_fee — decimal(38,2) — NOT NULL
    • price — decimal(38,2) — NOT NULL
    • profit — decimal(38,2) — NOT NULL
    • shipper_cancel_toggle — bit(1) — NOT NULL
    • accepted_at — datetime(6)
    • created_at — datetime(6) — NOT NULL
    • driver_id — bigint — Foreign key → driver.driver_id
    • dropoff_at — datetime(6)
    • dropoff_desired_at — datetime(6) — NOT NULL
    • pickup_at — datetime(6)
    • pickup_desired_at — datetime(6) — NOT NULL
    • shipper_id — bigint — Foreign key → shipper.shipper_id — NOT NULL
    • waypoint1_at — datetime(6)
    • waypoint2_at — datetime(6)
    • cargo_photo_url — varchar(255)
    • cargo_volume — varchar(255)
    • description — text
    • dropoff_address — varchar(255) — NOT NULL
    • dropoff_photo_url — varchar(255)
    • pickup_address — varchar(255) — NOT NULL
    • waypoint1_address — varchar(255)
    • waypoint2_address — varchar(255)
    • cargo_type — enum('BULK','GENERAL','HAZARDOUS','HEAVY','LONG_CARGO','MOVING','PALLET') — NOT NULL
    • current_location_point — point
    • dropoff_point — point — NOT NULL
    • pickup_point — point — NOT NULL
    • settlement_status — enum('INELIGIBLE','PAID','READY') — NOT NULL
    • shipment_status — enum('ASSIGNED','CANCELED','DONE','IN_TRANSIT','REQUESTED') — NOT NULL
    • waypoint1_point — point
    • waypoint2_point — point
    • estimated_distance — double
    • vehicle_type — enum('BULK','CARGO','DUMP','TANKER','VAN','WINGBODY') — NOT NULL

    shipper

    • shipper_id — bigint — Foreign key → user.user_id — NOT NULL

    user

    • user_id — bigint — Primary key — NOT NULL
    • birth — date — NOT NULL
    • is_push_enabled — bit(1) — NOT NULL
    • created_at — datetime(6) — NOT NULL
    • business_number — varchar(255)
    • device_token — varchar(255) — NOT NULL
    • email — varchar(255) — NOT NULL
    • name — varchar(255) — NOT NULL
    • password — varchar(255) — NOT NULL
    • phone — varchar(255) — NOT NULL
    • user_type — enum('DRIVER','SHIPPER') — NOT NULL

    vehicle

    • vehicle_id — bigint — Primary key — NOT NULL
    • can_freeze — bit(1) — NOT NULL
    • can_refrigerate — bit(1) — NOT NULL
    • weight_capacity — double — NOT NULL
    • driver_id — bigint — Foreign key → driver.driver_id — NOT NULL
    • vehicle_number — varchar(255) — NOT NULL
    • vehicle_type — enum('BULK','CARGO','DUMP','TANKER','VAN','WINGBODY')