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)