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 — 통신