FEMS

Tables (3)

abnormal_usage_log

  • log_id — INT — Primary key
  • facility_id — INT — Primary key — 설비
  • timestamp — DATETIME — 이상
  • energy_type — VARCHAR(50) — 에너지원
  • usage — DECIMAL — 당시
  • baseline — DECIMAL — 기준
  • threshold — DECIMAL — 이상
  • reason — VARCHAR(255) — 이상
  • acknowledged — BOOLEAN — 확인
  • resolution_status — VARCHAR(50) — 조치
  • resolution_details — TEXT — 조치
  • created_at — TIMESTAMP — 생성
  • facility_id (facility_id2) — INT — Foreign key → energy_consumption.facility_id
  • process_id — INT — Foreign key → energy_consumption.process_id
  • line_id — INT — Foreign key → energy_consumption.line_id
  • timestamp (timestamp2) — DATETIME

consumption_target

  • target_id — INT — Primary key
  • year — INT — 목표
  • month — INT — 목표
  • energy_type — VARCHAR(50) — 에너지원
  • target_value — DECIMAL — 목표
  • unit — VARCHAR(10) — 단위
  • created_at — TIMESTAMP — 생성
  • updated_at — TIMESTAMP — 수정

energy_consumption

  • timestamp — DATETIME — Primary key
  • facility_id — INT — Primary key
  • process_id — INT — Primary key
  • line_id — INT — Primary key
  • energy_type — VARCHAR(50)
  • total_consumption — DECIMAL
  • electricity_consumption — DECIMAL
  • gas_consumption — DECIMAL
  • water_consumption — DECIMAL
  • steam_consumption — DECIMAL
  • unit — VARCHAR(10)