powerhub
Tables (4)
control_history
- time — TIMESTAMPTZ — NOT NULL
- command_id — UUID — NOT NULL — 명령
- device_id — VARCHAR(50) — Foreign key → device.device_id — NOT NULL
- plant_id — VARCHAR(50) — NOT NULL
- resource_type — VARCHAR(20) — NOT NULL
- action — VARCHAR(50) — NOT NULL — 명령
- value — DOUBLE — 명령
- reason — VARCHAR(100) — 명령
- event_id — UUID — 연관
- ack_status — VARCHAR(20) — ACK
- ack_reason — VARCHAR(200) — ACK
- ack_time — TIMESTAMPTZ — ACK
device
- device_id — VARCHAR(50)
- plant_id — VARCHAR(50) — NOT NULL — 플랜트
- resource_type — VARCHAR(20) — NOT NULL — 설비
- device_name — VARCHAR(100) — NOT NULL — 설비명
- capacity_mw — DOUBLE — 설비
- installed_at — DATE — 설치일
- status — VARCHAR(20) — NOT NULL — 설비
- created_at — TIMESTAMPTZ — NOT NULL — 등록
event_log
- time — TIMESTAMPTZ — NOT NULL
- event_id — UUID — NOT NULL — 이벤트
- device_id — VARCHAR(50) — Foreign key → device.device_id — NOT NULL
- plant_id — VARCHAR(50) — NOT NULL
- resource_type — VARCHAR(20) — NOT NULL
- event_type — VARCHAR(50) — NOT NULL — 이벤트
- value — DOUBLE — NOT NULL — 감지
- threshold — DOUBLE — NOT NULL — 임계값
- severity — VARCHAR(20) — NOT NULL — 심각도
sensor_data
- time — TIMESTAMPTZ — NOT NULL
- device_id — VARCHAR(50) — Foreign key → device.device_id — NOT NULL — 설비
- plant_id — VARCHAR(50) — NOT NULL
- resource_type — VARCHAR(20) — NOT NULL
- value_p — DOUBLE — 현재
- value_kwh — DOUBLE — 적산
- soc — DOUBLE — ESS
- operating_mode — VARCHAR(20) — ESS
- reduce_ratio — DOUBLE — PV
- demand_max — DOUBLE — 최대
- comms_health — VARCHAR(10) — NOT NULL — 통신