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