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