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) — 한전 정보