test

Tables (11)

AdminInfo

  • admin_id — CHAR(10)
  • first_name — VARCHAR(50) — NOT NULL
  • last_name — VARCHAR(50) — NOT NULL
  • phone_number — VARCHAR(15)
  • email — VARCHAR(100)
  • address — VARCHAR(255)
  • role — ENUM('충전소 관리자', '시스템 관리자') — NOT NULL
  • can_register_station — BOOLEAN
  • registration_date — DATE

BatteryHealth

  • id — INT
  • device_id — CHAR(10) — NOT NULL
  • repair_status — ENUM('양호', '정상', '주의', '즉시수리')
  • soh — FLOAT
  • remaining_mileage — FLOAT
  • battery_voltage — FLOAT
  • battery_current — FLOAT
  • internal_resistance — FLOAT
  • update_time — TIMESTAMP

ChargerManagement

  • id — INT
  • station_id — CHAR(10) — NOT NULL
  • charger_id — CHAR(10) — NOT NULL
  • operation_status — BOOLEAN
  • highest_temperature — FLOAT
  • ambient_temperature — FLOAT
  • flame_sensor_alert — BOOLEAN
  • forced_stop_alert — BOOLEAN
  • fire_alert — BOOLEAN
  • update_time — TIMESTAMP

ChargingStation

  • station_id — CHAR(10)
  • station_name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(255)
  • latitude — DECIMAL(9, 6) — NOT NULL
  • longitude — DECIMAL(9, 6) — NOT NULL
  • admin_id — CHAR(10)
  • system_admin_id — CHAR(10)

ChargingStationRegistration

  • registration_id — INT
  • station_id — CHAR(10) — NOT NULL
  • system_admin_id — CHAR(10) — NOT NULL
  • registration_date — TIMESTAMP

ChargingStatus

  • id — INT
  • device_id — CHAR(10) — NOT NULL
  • ambient_temperature — FLOAT
  • charging_power — FLOAT
  • charging_state — ENUM('충전 중', '충전완료', '충전 대기중')
  • current_soc — FLOAT
  • total_soc — FLOAT
  • charging_type — ENUM('급속', '완속')
  • charger_id — CHAR(10)
  • update_time — TIMESTAMP

CorporateInfo

  • corporate_id — CHAR(10)
  • corporate_name — VARCHAR(100) — NOT NULL
  • contact_person — VARCHAR(50)
  • phone_number — VARCHAR(15)
  • email — VARCHAR(100)
  • address — VARCHAR(255)
  • registration_date — DATE

CorporateVehicleInfo

  • vehicle_id — CHAR(10)
  • vehicle_model — VARCHAR(50) — NOT NULL
  • manufacturer — VARCHAR(50) — NOT NULL
  • battery_manufacturer — VARCHAR(50)
  • battery_model — VARCHAR(50)
  • production_year — YEAR
  • mileage — FLOAT
  • unit — ENUM('km', 'mile')
  • registration_number — VARCHAR(20)
  • corporate_id — CHAR(10)

CustomerInfo

  • customer_id — CHAR(10)
  • first_name — VARCHAR(50) — NOT NULL
  • last_name — VARCHAR(50) — NOT NULL
  • phone_number — VARCHAR(15)
  • email — VARCHAR(100)
  • address — VARCHAR(255)
  • registration_date — DATE

FireSafety

  • id — INT
  • device_id — CHAR(10) — NOT NULL
  • fire_safety_status — ENUM('긴급', '주의', '정상')
  • overcharge — BOOLEAN
  • internal_short — BOOLEAN
  • high_temperature — BOOLEAN
  • overvoltage — BOOLEAN
  • overcurrent — BOOLEAN
  • charger_high_temperature — BOOLEAN
  • co_gas_detected — BOOLEAN
  • flame_detected — BOOLEAN
  • forced_stop_alert — BOOLEAN
  • emergency_call_button — BOOLEAN
  • battery_temperature — FLOAT
  • battery_heat_generation — FLOAT
  • web_camera_url — VARCHAR(255)
  • update_time — TIMESTAMP

VehicleInfo

  • vehicle_id — CHAR(10)
  • vehicle_model — VARCHAR(50) — NOT NULL
  • manufacturer — VARCHAR(50) — NOT NULL
  • battery_manufacturer — VARCHAR(50)
  • battery_model — VARCHAR(50)
  • production_year — YEAR
  • mileage — FLOAT
  • unit — ENUM('km', 'mile')
  • registration_number — VARCHAR(20)
  • owner_id — CHAR(10)