test1
Tables (9)
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')