ev
Tables (13)
charger
- id — BIGINT — Primary key — NOT NULL
- station_id — BIGINT — Foreign key → charging_station.id — NOT NULL
- external_charger_id — VARCHAR(20) — NOT NULL
- type — VARCHAR(10)
- location — VARCHAR(255)
- use_time — VARCHAR(100)
- state — VARCHAR(10)
- bus_id — VARCHAR(10)
- output — DECIMAL(10, 2)
- method — VARCHAR(20)
- year — INT
- floor_type — VARCHAR(20)
- floor_num — INT
charging_station
- id — BIGINT — Primary key — NOT NULL
- external_station_id — VARCHAR(50) — NOT NULL
- station_name — VARCHAR(255) — NOT NULL
- addr — VARCHAR(500)
- lat — DECIMAL(10, 7)
- lng — DECIMAL(10, 7)
- zcode — VARCHAR(10)
- zscode — VARCHAR(10)
- kind — VARCHAR(10)
- kind_detail — VARCHAR(10)
- charger_count — INT
ev
- id — BIGINT — Primary key — NOT NULL
- manufacturer — VARCHAR(100) — NOT NULL
- model — VARCHAR(100) — NOT NULL
- battery_type — VARCHAR(50)
- battery_capacity — DECIMAL(10, 2)
simulation
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- start_at — DATETIME — NOT NULL
- end_at — DATETIME — NOT NULL
- total_ev — INT — NOT NULL
- initial_soc_type — VARCHAR(20) — NOT NULL
- initial_soc_min — DECIMAL(5, 2) — NOT NULL
- initial_soc_max — DECIMAL(5, 2) — NOT NULL
- target_soc_type — VARCHAR(20) — NOT NULL
- target_soc_min — DECIMAL(5, 2) — NOT NULL
- target_soc_max — DECIMAL(5, 2) — NOT NULL
- charge_order — VARCHAR(30) — NOT NULL
- random_seed — BIGINT — NOT NULL
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
simulation_charger
- id — BIGINT — Primary key — NOT NULL
- simulation_station_id — BIGINT — Foreign key → simulation_charging_station.id — NOT NULL
- original_charger_id — VARCHAR(20)
- type — VARCHAR(10)
- location — VARCHAR(255)
- use_time — VARCHAR(100)
- state — VARCHAR(10)
- bus_id — VARCHAR(10)
- output — DECIMAL(10, 2)
- method — VARCHAR(20)
- year — INT
- floor_type — VARCHAR(20)
- floor_num — INT
simulation_charging_station
- id — BIGINT — Primary key — NOT NULL
- simulation_id — BIGINT — Foreign key → simulation.id — NOT NULL
- original_station_id — VARCHAR(50)
- station_name — VARCHAR(255) — NOT NULL
- addr — VARCHAR(500)
- lat — DECIMAL(10, 7)
- lng — DECIMAL(10, 7)
- zcode — VARCHAR(10)
- zscode — VARCHAR(10)
- kind — VARCHAR(10)
- kind_detail — VARCHAR(10)
- charger_count — INT
simulation_departure_probability
- id — BIGINT — Primary key — NOT NULL
- simulation_id — BIGINT — Foreign key → simulation.id — NOT NULL
- start_time — TIME — NOT NULL
- end_time — TIME — NOT NULL
- probability — DECIMAL(7, 4) — NOT NULL
simulation_ev
- id — BIGINT — Primary key — NOT NULL
- simulation_id — BIGINT — Foreign key → simulation.id — NOT NULL
- source_ev_id — BIGINT — Foreign key → ev.id
- manufacturer — VARCHAR(100) — NOT NULL
- model — VARCHAR(100) — NOT NULL
- battery_capacity — DECIMAL(10, 2)
- arrival_time — DATETIME — NOT NULL
- expected_departure_time — DATETIME — NOT NULL
- actual_departure_time — DATETIME
- status — VARCHAR(30) — NOT NULL
- max_charging_power — DECIMAL(10, 2)
- current_soc — DECIMAL(5, 2)
- initial_soc — DECIMAL(5, 2) — NOT NULL
- target_soc — DECIMAL(5, 2) — NOT NULL
simulation_ev_composition
- id — BIGINT — Primary key — NOT NULL
- simulation_id — BIGINT — Foreign key → simulation.id — NOT NULL
- ev_id — BIGINT — Foreign key → ev.id — NOT NULL
- ratio — DECIMAL(7, 4) — NOT NULL
- count — INT — NOT NULL
simulation_ev_time_series
- id — BIGINT — Primary key — NOT NULL
- simulation_ev_id — BIGINT — Foreign key → simulation_ev.id — NOT NULL
- simulation_charger_id — BIGINT — Foreign key → simulation_charger.id
- timestamp — DATETIME — NOT NULL
- soc — DECIMAL(5, 2) — NOT NULL
- charging_power — DECIMAL(10, 2) — NOT NULL
simulation_result
- id — BIGINT — Primary key — NOT NULL
- simulation_id — BIGINT — Foreign key → simulation.id — NOT NULL
- peak_power — DECIMAL(10, 2)
- avg_power — DECIMAL(10, 2)
- total_ev — INT — NOT NULL
- success_ev — INT — NOT NULL
- failed_ev — INT — NOT NULL
- leave_ev — INT — NOT NULL
simulation_time_series
- id — BIGINT — Primary key — NOT NULL
- simulation_id — BIGINT — Foreign key → simulation.id — NOT NULL
- timestamp — DATETIME — NOT NULL
- total_power — DECIMAL(10, 2) — NOT NULL
users
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL