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