진주,함양, 여수

테이블 (3)

hamyang_lv01

  • s_time — VARCHAR(20) — 기본 키 — NOT NULL
  • n_line_voltage_rs — INT(11)
  • n_line_voltage_st — INT(11)
  • n_line_voltage_tr — INT(11)
  • n_phase_voltage_r — INT(11)
  • n_phase_voltage_s — INT(11)
  • n_phase_voltage_t — INT(11)
  • n_phase_current_r — INT(11)
  • n_phase_current_s — INT(11)
  • n_phase_current_t — INT(11)
  • n_watt_total — INT(11)
  • n_var_total — INT(11)
  • n_va_total — INT(11)
  • n_frequency — INT(11)
  • n_powerfactor — INT(11)
  • n_watt_hour — INT(11)
  • n_var_hour — INT(11)
  • n_water_level_basement — INT(11)
  • bl_water_level_high_alarm — TINYINT(4)
  • bl_water_level_low_alarm — TINYINT(4)
  • bl_dorm_booster_on — TINYINT(4)
  • bl_dorm_booster_alarm — TINYINT(4)
  • bl_machine_room_drain_alarm — TINYINT(4)
  • bl_dorm_pit_drain_alarm — TINYINT(4)
  • bl_dorm_boiler_1_1_on — TINYINT(4)
  • bl_dorm_boiler_1_2_on — TINYINT(4)
  • bl_dorm_boiler_1_1_alarm — TINYINT(4)
  • bl_dorm_boiler_1_2_alarm — TINYINT(4)
  • bl_dorm_heating_pump1_on — TINYINT(4)
  • bl_dorm_heating_pump2_on — TINYINT(4)
  • bl_dorm_heating_pump3_on — TINYINT(4)
  • bl_dorm_boiler_2_on — TINYINT(4)
  • bl_dorm_boiler_2_alarm — TINYINT(4)
  • bl_dorm_hotwater_pump1_on — TINYINT(4)
  • bl_dorm_hotwater_pump2_on — TINYINT(4)
  • bl_dorm_hotwater_dispenser_pump1_on — TINYINT(4)
  • bl_dorm_hotwater_dispenser_pump2_on — TINYINT(4)
  • bl_machine_room_supply_fan_on — TINYINT(4)
  • bl_machine_room_exhaust_fan_on — TINYINT(4)
  • bl_ele_room_supply_fan_on — TINYINT(4)
  • bl_ele_room_exhaust_fan_on — TINYINT(4)
  • bl_ground_heat_on — TINYINT(4)
  • bl_ground_heat_alarm — TINYINT(4)
  • bl_dorm_buzzer_on — TINYINT(4)
  • bl_dinning_pit_drain_alarm — TINYINT(4)
  • bl_dinning_boiler_on — TINYINT(4)
  • bl_dinning_boiler_alarm — TINYINT(4)
  • bl_dinning_hotwater_pump1_on — TINYINT(4)
  • bl_dinning_hotwater_pump2_on — TINYINT(4)
  • bl_dinning_dispenser_pump1_on — TINYINT(4)
  • bl_dinning_dispenser_pump2_on — TINYINT(4)
  • bl_dinning_buzzer_on — TINYINT(4)

jinju_lv01

  • s_time — VARCHAR(20) — 기본 키 — NOT NULL
  • n_phase_voltage_r — INT(11)
  • n_phase_voltage_s — INT(11)
  • n_phase_voltage_t — INT(11)
  • n_line_voltage_rs — INT(11)
  • n_line_voltage_st — INT(11)
  • n_line_voltage_tr — INT(11)
  • n_zero_current — INT(11)
  • n_phase_current_r — INT(11)
  • n_phase_current_s — INT(11)
  • n_phase_current_t — INT(11)
  • n_frequency — INT(11)
  • n_zero_voltage_max — INT(11)
  • n_watt_total — INT(11)
  • n_var_total — INT(11)
  • n_powerfactor — INT(11)
  • n_watt_hour — INT(11)
  • n_var_hour — INT(11)
  • bl_hotwater_boiler1_status — TINYINT(4)
  • bl_hotwater_boiler1_alarm — TINYINT(4)
  • bl_hotwater_boiler2_status — TINYINT(4)
  • bl_hotwater_boiler2_alarm — TINYINT(4)
  • bl_heating_boiler1_staus — TINYINT(4)
  • bl_heating_boiler1_alarm — TINYINT(4)
  • bl_heating_boiler2_staus — TINYINT(4)
  • bl_heating_boiler2_alarm — TINYINT(4)

yeosoo_lv01

  • s_time — VARCHAR(20) — 기본 키 — NOT NULL
  • n_line_voltage_rs — INT(11)
  • n_line_voltage_st — INT(11)
  • n_line_voltage_tr — INT(11)
  • n_phase_voltage_r — INT(11)
  • n_phase_voltage_s — INT(11)
  • n_phase_voltage_t — INT(11)
  • n_phase_current_r — INT(11)
  • n_phase_current_s — INT(11)
  • n_phase_current_t — INT(11)
  • n_watt_total — INT(11)
  • n_var_total — INT(11)
  • n_va_total — INT(11)
  • n_frequency — INT(11)
  • n_powerfactor — INT(11)
  • n_watt_hour — INT(11)
  • n_var_hour — INT(11)
  • n_water_level_basement — INT(11)
  • bl_water_level_high_alarm — TINYINT(4)
  • bl_water_level_low_alarm — TINYINT(4)
  • bl_dorm_booster_on — TINYINT(4)
  • bl_dorm_booster_alarm — TINYINT(4)
  • bl_machine_room_drain_alarm — TINYINT(4)
  • bl_dorm_pit_drain_alarm — TINYINT(4)
  • bl_dorm_boiler_1_1_on — TINYINT(4)
  • bl_dorm_boiler_1_2_on — TINYINT(4)
  • bl_dorm_boiler_1_1_alarm — TINYINT(4)
  • bl_dorm_boiler_1_2_alarm — TINYINT(4)
  • bl_dorm_heating_pump1_on — TINYINT(4)
  • bl_dorm_heating_pump2_on — TINYINT(4)
  • bl_dorm_heating_pump3_on — TINYINT(4)
  • bl_dorm_boiler_2_on — TINYINT(4)
  • bl_dorm_boiler_2_alarm — TINYINT(4)
  • bl_dorm_hotwater_pump1_on — TINYINT(4)
  • bl_dorm_hotwater_pump2_on — TINYINT(4)
  • bl_dorm_hotwater_dispenser_pump1_on — TINYINT(4)
  • bl_dorm_hotwater_dispenser_pump2_on — TINYINT(4)
  • bl_machine_room_supply_fan_on — TINYINT(4)
  • bl_machine_room_exhaust_fan_on — TINYINT(4)
  • bl_ele_room_supply_fan_on — TINYINT(4)
  • bl_ele_room_exhaust_fan_on — TINYINT(4)
  • bl_ground_heat_on — TINYINT(4)
  • bl_ground_heat_alarm — TINYINT(4)
  • bl_dorm_buzzer_on — TINYINT(4)
  • bl_dinning_pit_drain_alarm — TINYINT(4)
  • bl_dinning_boiler_on — TINYINT(4)
  • bl_dinning_boiler_alarm — TINYINT(4)
  • bl_dinning_hotwater_pump1_on — TINYINT(4)
  • bl_dinning_hotwater_pump2_on — TINYINT(4)
  • bl_dinning_dispenser_pump1_on — TINYINT(4)
  • bl_dinning_dispenser_pump2_on — TINYINT(4)
  • bl_dinning_buzzer_on — TINYINT(4)