PlantFactory
Tables (15)
actuator
- id (actuator_id) — int(5) — Primary key — NOT NULL
- node_id — int(5) — Foreign key → actuator_node.node_id — NOT NULL
- major_id — int(5)
- minor_id — int(5)
- actuator_name — varchar(20)
- phase — int(5)
- certificate_authority — varchar(20)
- company_code — varchar(20)
- product_type — varchar(20)
- product_code — varchar(20)
- protocol_ver — varchar(20)
- channel_num — int(5)
- serial_num — varchar(20)
- node_num — int(5)
- mode — int(5)
- actuator_use — int(5)
- ins_date — datetime
- upd_date — datetime
actuator_history
- id (actuator_history_id) — int(10) — Primary key — NOT NULL
- actuator_id — int(5) — Foreign key → actuator.id — NOT NULL
- onoff — int(5)
- ins_date — datetime
- upd_date — datetime
actuator_node
- node_id — int(5) — Primary key — NOT NULL
- dev_id — int(5)
- name — varchar(20)
- ins_date — datetime
- upd_date — datetime
actuator_sts
- id (actuator_sts_id) — int(10) — Primary key — NOT NULL
- onoff — int(5)
- always_chk — int(5)
- starttime — int(10)
- endtime — int(10)
- day_chk — int(5)
- overload_chk — int(5)
- op_worktime — int(10)
- op_stoptime — int(10)
- auto_type — int(5)
- pilot_signal — int(5)
- conn — varchar(10)
- Interface — varchar(10)
- dc_ac — int(5)
- terminal — varchar(10)
- op_nowtime — int(10)
- ins_date — datetime
- upd_date — datetime
- id (actuator_id) — int(5) — Foreign key → actuator.id — NOT NULL
dong
- id (dong_id) — int(5) — Primary key — NOT NULL
- maincontrol_id — int(5) — Foreign key → maincontrol.id — NOT NULL
- dong_name — varchar(20)
- manager — varchar(20)
- ins_date — datetime
- upd_date — datetime
dong_actuator
- id (dong_actuator_id) — int(5) — Primary key — NOT NULL
- dong_id — int(5) — Foreign key → dong.id — NOT NULL
- actuator_id — int(5) — Foreign key → actuator.id — NOT NULL
- ins_date — datetime
- upd_date — datetime
dong_sensor
- id (dong_sensor_id) — int(5) — Primary key — NOT NULL
- dong_id — int(5) — Foreign key → dong.id — NOT NULL
- sensor_id — int(5) — Foreign key → sensor.id — NOT NULL
- ins_date — datetime
- upd_date — datetime
maincontrol
- id (maincontrol_id) — int(5) — Primary key — NOT NULL
- sector_id — int(5) — Foreign key → sector.id — NOT NULL
- maincontrol_name — varchar(20)
- ins_date — datetime
- upd_date — datetime
sector
- id (sector_id) — int(5) — Primary key — NOT NULL
- user_id — int(5) — Foreign key → user.id — NOT NULL
- sector_name — varchar(20)
- ins_date — datetime
- upd_date — datetime
sensor
- id (sensor_id) — int(5) — Primary key — NOT NULL
- node_id — int(5) — Foreign key → sensor_node.node_id — NOT NULL
- major_id — int(5)
- minor_id (mimor_id) — int(5)
- sensor_name — varchar(30)
- sensor_min — int(10)
- sensor_max — int(10)
- sensor_correct — int(10)
- sensor_spec — varchar(30)
- certificate_authority — varchar(20)
- company_code — varchar(20)
- product_type — varchar(20)
- product_code — varchar(20)
- protocol_ver — varchar(20)
- channel_num — int(5)
- serial_num — varchar(20)
- desc — varchar(20)
- loc — varchar(20)
- target — varchar(20)
- value_unit — varchar(20)
- sensor_use — int(5)
- ins_date — datetime
- upd_date — datetime
sensor_actuator
- id (sensor_actuator_id) — int(5) — Primary key — NOT NULL
- id (sensor_id) — int(5) — Foreign key → sensor.id — NOT NULL
- id (actuator_id) — int(5) — Foreign key → actuator.id — NOT NULL
- id (sensor_sts_id) — int(10) — Foreign key → sensor_sts.sts_id — NOT NULL
- id (actuator_sts_id) — int(10) — Foreign key → actuator_sts.id — NOT NULL
- ins_date — datetime
- upd_date — datetime
sensor_history
- history_id (sensor_history_id) — int(10) — Primary key — NOT NULL
- sensor_id — int(5) — Foreign key → sensor.id — NOT NULL
- sensor_val — int(10)
- ins_date — datetime
- upd_date — datetime
sensor_node
- node_id — int(5) — Primary key — NOT NULL
- dev_id — int(5)
- name — varchar(20)
- ins_date — datetime
- upd_date — datetime
sensor_sts
- sts_id (sensor_sts_id) — int(10) — Primary key — NOT NULL
- sensor_status — varchar(20)
- start (sensor_start) — int(5)
- stop (sensor_stop) — int(5)
- logicblock_id — int(5)
- logicblock_con — int(5)
- ins_date — datetime
- upd_date — datetime
- id (sensor_id) — int(5) — Foreign key → sensor.id — NOT NULL
user
- id (user_id) — int(5) — Primary key — NOT NULL
- login_id — varchar(20)
- password — varchar(20)
- name — varchar(20)
- phone — varchar(20)
- address — varchar(50)
- sex — int(2)
- birth — varchar(10)
- email — varchar(30)
- point — int(10)
- ins_date — datetime
- upd_date — datetime