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