undefined

테이블 (6)

ai_hub_data

  • ai_hub_data_seq (ahd_seq) — int(4) — 기본 키 — NOT NULL
  • ai_hub_data_time (ahd_time) — date
  • ai_hub_data_label (ahd_label) — varchar(2)
  • ai_hub_data_cumulative_amount_of_electricity (ahd_caoc) — varchar(20)
  • ai_hub_data_temperatrue (ahd_temp) — varchar(20)
  • ai_hub_data_phase_voltage_average (ahd_pva) — varchar(20)
  • ai_hub_data_line_to_line_voltage_average (ahd_lva) — varchar(20)
  • ai_hub_data_voltage_harmonics_mean (ahd_vhm) — varchar(20)
  • ai_hub_data_current_average (ahd_ca) — varchar(20)
  • ai_hub_data_current_harmonics_mean (ahd_chm) — varchar(20)
  • ai_hub_data_power_factor_average (ahd_pfa) — varchar(20)
  • ai_hub_data_reactive_power_average (ahd_rpa) — varchar(20)
  • ai_hub_data_frequency (ahd_freq) — varchar(20)
  • ai_hub_data_effective_power_average (ahd_epa) — varchar(20)
  • ai_hub_data_R_phase_voltage (ahd_Rpv) — varchar(20)
  • ai_hub_data_R_line_to_line_voltage (ahd_Rlv) — varchar(20)
  • ai_hub_data_R_phase_current (ahd_Rpc) — varchar(20)
  • ai_hub_data_R_phase_effective_power (ahd_Rpep) — varchar(20)
  • ai_hub_data_R_phase_reactive_power (ahd_Rprp) — varchar(20)
  • ai_hub_data_R_phase_factor (ahd_Rpf) — varchar(20)
  • ai_hub_data_R_phase_voltage_harmonics (ahd_Rpvh) — varchar(20)
  • ai_hub_data_R_phase_current_harmonics (ahd_Rpch) — varchar(20)
  • ai_hub_data_S_phase_voltage (ahd_Spv) — varchar(20)
  • ai_hub_data_S_line_to_line_voltage (ahd_Slv) — varchar(20)
  • ai_hub_data_S_phase_currnet (ahd_Spc) — varchar(20)
  • ai_hub_data_S_phase_effective_power (ahd_Spep) — varchar(20)
  • ai_hub_data_S_phase_reactive_power (ahd_Sprp) — varchar(20)
  • ai_hub_data_S_phase_factor (ahd_Spf) — varchar(20)
  • ai_hub_data_S_phase_voltage_harmonics (ahd_Spvh) — varchar(20)
  • ai_hub_data_S_phase_current_harmonics (ahd_Spch) — varchar(20)
  • ai_hub_data_T_phase_voltage (ahd_Tpv) — varchar(20)
  • ai_hub_data_T_line_to_line_voltage (ahd_Tlv) — varchar(20)
  • ai_hub_data_T_phase_current (ahd_Tpc) — varchar(20)
  • ai_hub_data_T_phase_effective_power (ahd_Tpep) — varchar(20)
  • ai_hub_data_T_phase_reactive_power (ahd_Tprp) — varchar(20)
  • ai_hub_data_T_phase_factor (ahd_Tpf) — varchar(20)
  • ai_hub_data_T_phase_voltage_harmonics (ahd_Tpvh) — varchar(20)
  • ai_hub_data_T_phase_current_harmonics (ahd_Tpch) — varchar(20)

fems_log

  • isrt_date — date — 기본 키 — NOT NULL
  • isrt_dttm — date — 기본 키
  • 업체명 (co_name) — varchar(20) — 외래 키 → 업체.업체명 — NOT NULL
  • ID (user_id) — varchar(20) — 외래 키 → 업체.ID — NOT NULL
  • fems_equip_id — varchar(20)
  • fems_address — varchar(20)
  • fems_volt — int(10)
  • fems_current — int(10)
  • fems_factor — int(10)
  • fems_power — int(10)
  • fems_react_power — int(10)
  • fems_no — varchar(20)

result_sensor

  • sensor_time — date — 기본 키 — NOT NULL
  • 업체명 (co_name) — varchar(20) — 외래 키 → 업체.업체명 — NOT NULL
  • ID (user_id) — varchar(20) — 외래 키 → 업체.ID — NOT NULL
  • sensor_co2 — int(10)
  • sensor_hcho — int(10)
  • sensor_humidity — int(10)
  • sensor_pm100 — int(10)
  • sensor_pm25 — int(10)
  • sensor_temp — float(10)
  • sensor_temperature — int(10)
  • sensor_vibr — float(10)

사용자 (user)

  • ID (user_id) — varchar(20) — 기본 키 — NOT NULL
  • 패스워드 (user_pw) — varchar(20)
  • 이름 (user_name) — varchar(20)

설비 (facilities)

  • 설비명 (fac_name) — varchar(20) — 기본 키 — NOT NULL
  • 업체명 (co_name2) — varchar(20) — 외래 키 → 업체.업체명 — NOT NULL
  • ID (user_id) — varchar(20) — 외래 키 → 업체.ID — NOT NULL
  • 설비 종류 (fac_type) — varchar(20)
  • 설비 제조사 (fac_mfg) — varchar(20) — a facility manufacturer
  • 제작 연도 (fac_yr_prodn) — date — the year of production
  • 정격 용량 (fac_rated_capa) — int(10) — rated capacity
  • 정격 전압 (fac_rated_volt) — int(10) — rated voltage

업체 (company)

  • 업체명 (co_name) — varchar(20) — 기본 키 — NOT NULL
  • ID (user_id) — varchar(20) — 외래 키 → 사용자.ID — NOT NULL
  • 업체주소 (co_locate) — varchar(100)
  • 설립연도 (co_estb) — date — 회사 설립연도
  • 업종 (co_busi) — varchar(20) — 업종 category of business
  • 업태 (co_busi_con) — varchar(20) — business conditions
  • 주생산품 (co_product) — varchar(20) — 주생산품
  • 계약전력 (co_cont_hist) — int(10) — contract history
  • 선택 요금제 (co_sel_paysys) — varchar(20) — select payment system
  • 한전 정보 (co_kepco_info) — varchar(100) — 한전 정보