PL2

Tables (9)

control

  • control_id — int(5) — Primary key — NOT NULL
  • auto_man — int(5)
  • status — int(5)
  • normal — int(5)
  • switch — int(5)
  • group_id — int(5) — Foreign key → groupp.group_id — NOT NULL

control_auto

  • control_auto_id — int(5) — Primary key — NOT NULL
  • sensor — int(5)
  • timer — int(5)
  • control_id — int(5) — Foreign key → control.control_id — NOT NULL

control_sensor

  • control_sensor_id — int(5) — Primary key — NOT NULL
  • starttime — int(5)
  • endtime — int(5)
  • worktime — int(5)
  • stoptime — int(5)
  • con_single — int(5)
  • con_and — int(5)
  • con_or — int(5)
  • repeat — int(5)
  • control_auto_id — int(5) — Foreign key → control_auto.control_auto_id — NOT NULL

control_timer

  • control_timer_id — int(5) — Primary key — NOT NULL
  • starttime — int(5)
  • endtime — int(5)
  • repeat — int(5)
  • control_auto_id — int(5) — Foreign key → control_auto.control_auto_id — NOT NULL

groupp

  • group_id — int(5) — Primary key — NOT NULL
  • dong — int(5)
  • single — int(5)
  • pair — int(5)
  • forswitch — int(5)

portoutput

  • portoutput_id — int(5) — Primary key — NOT NULL
  • group_id — int(5) — Foreign key → groupp.group_id — NOT NULL

portswitch

  • portswitch_id — int(5) — Primary key — NOT NULL
  • group_id — int(5) — Foreign key → groupp.group_id — NOT NULL

sensor

  • sensor_id — int(5) — Primary key — NOT NULL
  • sensor_name — varchar(5)
  • alarm_set — int(5)
  • valuecalc — int(5)
  • range — int(5)
  • min — int(5)
  • max — int(5)
  • min_avg — int(5)
  • max_avg — int(5)
  • alarm_type — int(5)
  • group_id — int(5) — Foreign key → groupp.group_id — NOT NULL

sensor_history

  • sensor_history_id — int(5) — Primary key — NOT NULL
  • value — int(5)
  • sensor_id — int(5) — Foreign key → sensor.sensor_id — NOT NULL