KEICO ERD
Tables (5)
ENERGY_COST_PREDICTION (( 월별 사용 요금 예측 테이블))
- COST_SQ (cost_sq) — BIGINT — Primary key — NOT NULL
- GW_ID (gw_id) — VARCHAR(255)
- BUILDING_TYPE_CODE (building_type_code) — VARCHAR(255)
- FEE_TYPE_CODE (fee_type_code) — VARCHAR(255)
- MONTHLY_USAGE (monthly_usage) — DOUBLE
- MONTHLY_COST (monthly_cost) — DOUBLE
- LOCALMONTH (localmonth) — DATE
ENERGY_GW_PREDICTION ((1시간 단위 GW별 데이터 예측 테이블))
- GW_SQ (gw_sq) — BIGINT — Primary key — NOT NULL
- GW_ID (gw_id) — VARCHAR(255)
- USAGE (usage) — DOUBLE
- LOCALTIME (localtime) — DATETIME
ENERGY_GW_USAGE ((1시간 단위 GW별 사용량 데이터 수집 테이블))
- GW_SQ (gw_sq) — BIGINT — Primary key — NOT NULL
- GW_ID (gw_id) — VARCHAR(255)
- BUILDING_TYPE_CODE (building_type_code) — VARCHAR(255)
- FEE_TYPE_CODE (fee_type_code) — VARCHAR(255)
- LOCALMINUTE (localminute) — DATETIME
- DAY_OF_WEEK (day_of_week) — VARCHAR(10)
- USAGE (usage) — DOUBLE
- TEMPERATURE (temperature) — DOUBLE
- HUMIDITY (humidity) — DOUBLE
- COM_ST (com_st) — BOOLEAN
ENERGY_PLUG_PREDICTION ((15분 단위 PLUG별 데이터 예측 테이블))
- PLUG_SQ (plug_sq) — BIGINT — Primary key — NOT NULL
- PLUG_ID (plug_id) — VARCHAR(255)
- GW_ID (gw_id) — VARCHAR(255)
- PLUG_CODE (plug_code) — VARCHAR(255)
- USAGE (usage) — DOUBLE
- LOCALTIME (localtime) — DATETIME
ENERGY_PLUG_USAGE ((15분 단위 PLUG별 사용량 데이터 수집 테이블))
- PLUG_SQ (plug_sq) — BIGINT — Primary key — NOT NULL
- GW_ID (gw_id) — VARCHAR(255)
- PLUG_ID (plug_id) — VARCHAR(255)
- PLUG_CODE (plug_code) — VARCHAR(255)
- LOCALMINUTE (localminute) — DATETIME
- DAY_OF_WEEK (day_of_week) — VARCHAR(10)
- USAGE (usage) — DOUBLE
- TEMPERATURE (temperature) — DOUBLE
- HUMIDITY (humidity) — DOUBLE
- COM_ST (com_st) — BOOLEAN