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