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)