veylo

Tables (10)

payments

  • id — INT
  • ride_id — INT — Foreign key → rides.id — NOT NULL
  • amount — INT — NOT NULL
  • status — ENUM('pending','success','failed') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

ride_boarding

  • id — INT
  • ride_id — INT — Foreign key → rides.id — NOT NULL
  • auth_code — VARCHAR(100) — NOT NULL
  • status — ENUM('issued','used','expired') — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • verified_at — TIMESTAMP

ride_routes

  • id — INT
  • ride_id — INT — Foreign key → rides.id — NOT NULL
  • latitude — DECIMAL(10,6) — NOT NULL
  • longitude — DECIMAL(10,6) — NOT NULL
  • sequence_order — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

rides

  • id — INT
  • passenger_id — INT — Foreign key → users.id — NOT NULL
  • vehicle_id — INT — Foreign key → vehicles.id
  • start_address — VARCHAR(255)
  • start_lat — DECIMAL(10,6) — NOT NULL
  • start_lng — DECIMAL(10,6) — NOT NULL
  • end_address — VARCHAR(255)
  • end_lat — DECIMAL(10,6) — NOT NULL
  • end_lng — DECIMAL(10,6) — NOT NULL
  • next_destination_type — VARCHAR(50)
  • next_address — VARCHAR(255)
  • next_lat — DECIMAL(10,6)
  • next_lng — DECIMAL(10,6)
  • status — ENUM( 'requested', 'reserved', 'matched', 'vehicle_arrived', 'boarded', 'driving', 'ended', 'canceled' ) — NOT NULL
  • estimated_price — INT
  • estimated_distance — FLOAT
  • estimated_time — INT
  • final_price — INT
  • final_distance — FLOAT
  • passenger_rating — INT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • reserved_at — TIMESTAMP
  • boarded_at — TIMESTAMP
  • ended_at — TIMESTAMP

service_hotspots

  • id — INT
  • name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(255)
  • lat — DECIMAL(10,6) — NOT NULL
  • lng — DECIMAL(10,6) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

user_accounts

  • user_id — INT — Foreign key → users.id
  • bank_code — VARCHAR(10) — NOT NULL
  • account_number — VARCHAR(50) — NOT NULL
  • account_holder — VARCHAR(100) — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

users

  • id — INT
  • login_id — VARCHAR(50) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • phone_number — VARCHAR(20) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

vehicle_settings

  • vehicle_id — INT — Foreign key → vehicles.id
  • mode — BOOLEAN — NOT NULL
  • operating_days — VARCHAR(7)
  • operating_start_time — TIME
  • operating_end_time — TIME
  • min_battery — INT — NOT NULL
  • return_address — VARCHAR(255)
  • return_lat — DECIMAL(10,6)
  • return_lng — DECIMAL(10,6)
  • idle_strategy — ENUM('stay','hotspot','return_base')
  • idle_parking_address — VARCHAR(255)
  • idle_parking_lat — DECIMAL(10,6)
  • idle_parking_lng — DECIMAL(10,6)
  • updated_at — TIMESTAMP — NOT NULL

vehicle_status

  • vehicle_id — INT — Foreign key → vehicles.id
  • door_status — ENUM('locked','unlocked') — NOT NULL
  • current_lat — DECIMAL(10,6)
  • current_lng — DECIMAL(10,6)
  • current_status — ENUM( 'idle', 'dispatching', 'arrived', 'driving', 'returning' ) — NOT NULL
  • current_ride_id — INT — Foreign key → rides.id
  • battery_percent — INT — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

vehicles

  • id — INT
  • owner_id — INT — Foreign key → users.id — NOT NULL
  • simulator_vehicle_id — VARCHAR(100)
  • vehicle_number — VARCHAR(20) — NOT NULL
  • vehicle_model — VARCHAR(100) — NOT NULL
  • battery_capacity — INT
  • energy_efficiency — FLOAT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL