UPS

Tables (7)

cb_control (분전반 설정값 저장)

  • device_number (Key) — int — Primary key — NOT NULL
  • breaker_vol (Field) — float

cb_event (분전반 보드 이벤트데이터 전송)

  • device_number (Key) — int — Primary key — NOT NULL
  • measure_time (Key2) — timestamp — Primary key — NOT NULL
  • sum_power (Field) — float
  • power (Field2) — float
  • voltage (Field3) — float
  • current (Field4) — float
  • Igo (Field5) — float
  • Igr (Field6) — float
  • Igc (Field7) — float
  • overcurrent_alarm (Field8) — tinyint
  • igo_alarm (Field9) — tinyint
  • igr_alarm (Field10) — tinyint

cb_sensor (분전반 주기 데이터 전송)

  • device_number (Key) — int — Primary key — NOT NULL
  • measure_time (Key2) — timestamp — Primary key — NOT NULL
  • sum_power (Field2) — float
  • power (Field3) — float
  • voltage (Field4) — float
  • current (Field5) — float
  • Igo (Field6) — float
  • Igr (Field7) — float
  • Igc (Field8) — float

erm_info (접지저항 측정값 정보)

  • device_number (Key) — int — Primary key — NOT NULL
  • measure_time (Key2) — timestamp — Primary key — NOT NULL
  • ground_registance (Field) — float
  • ground_registance_alarm (Field2) — tinyint

infrared_heat_info (적외선 열화상 정보)

  • device_number (Key) — int — Primary key — NOT NULL
  • measure_time (Key2) — timestamp — Primary key — NOT NULL
  • info (Field) — float
  • alarm (Field2) — tinyint

tess_event (3상 분전반 이벤트 데이터 전송)

  • scp_id (Key) — int — Primary key — NOT NULL
  • measure_time (Key2) — timestamp — Primary key — NOT NULL
  • a_energy (Field2) — float
  • a_power (Field3) — float
  • a_voltage (Field4) — float
  • a_current (Field5) — float
  • a_factor (Field6) — float
  • a_frequency (Field7) — float
  • b_energy (Field8) — flaot
  • b_power (Field9) — float
  • b_voltage (Field10) — float
  • b_current (Field11) — float
  • b_factor (Field12) — float
  • b_frequency (Field13) — float
  • c_energy (Field14) — flaot
  • c_power (Field15) — float
  • c_voltage (Field16) — float
  • c_current (Field17) — float
  • c_factor (Field18) — float
  • c_frequency (Field19) — flaot
  • a_overcurrent_alarm (Field) — float
  • b_overcurrent_alarm (Field20) — float
  • c_overcurrent_alarm (Field21) — float
  • current_unbalanced_alarm (Field22) — float

tess_sensor (3상 분전반 주기 데이터 전송)

  • scp_id (Key) — int — Primary key — NOT NULL
  • measure_time (Key2) — timestamp — Primary key — NOT NULL
  • a_energy (Field2) — float
  • a_power (Field3) — float
  • a_voltage (Field4) — float
  • a_current (Field5) — float
  • a_factor (Field6) — float
  • a_frequency (Field7) — float
  • b_energy (Field8) — flaot
  • b_power (Field9) — float
  • b_voltage (Field10) — float
  • b_current (Field11) — float
  • b_factor (Field12) — float
  • b_frequency (Field13) — float
  • c_energy (Field14) — flaot
  • c_power (Field15) — float
  • c_voltage (Field16) — float
  • c_current (Field17) — float
  • c_factor (Field18) — float
  • c_frequency (Field19) — flaot