A-ROS Server ERD

Tables (11)

env_filejob_cfg (Untitled2)

  • Equipment Name (Key) — Primary key — NOT NULL
  • Job ID (Key2) — Primary key — NOT NULL
  • Job Use (Field)
  • Delay (Field2)
  • Interval (Field3)
  • Protect Type (Field4)
  • FTP Mode (Field5)
  • Signal Mode (Field6)
  • Append Mode (Field7)
  • FTP IP Address (Field8)
  • FTP ID (Field9)
  • FTP Password (Field10)
  • Signal File Extension Name (Field11)
  • Data File Extension Name (Field12)
  • Last Read Offset (Field13)
  • Last File Name (Field14)
  • Last Access Time (Field15)
  • Signal File Directory Path (Field16)
  • Data file Directoryh Path (Field17)
  • Download Directory Path (Field18)
  • File Type (Field19)

env_plc_cfg (CopyOfUntitled2)

  • Equipment Name (Key) — Primary key — NOT NULL
  • PLC ID (Key2) — Primary key — NOT NULL
  • PLC Use (Field)
  • PLC IP (Field2)
  • Port (Field3)
  • Logical Station Number (Field4)
  • Bit Scan Start Address (Field5)
  • Bit Scan End Address (Field6)
  • Word Scan Start Address (Field7)
  • Word Scan End Address (Field8)
  • PLC Type (Field9)

env_wsv_cfg (Untitled11)

  • Web Socket Service Name (Key) — Primary key — NOT NULL
  • Server IP (Key2) — Primary key — NOT NULL
  • Server Port (Key3) — Primary key — NOT NULL
  • Service Use (Field)
  • Broadcast Use (Field2)

eqp_history (Untitled10)

  • Changed Start Time (Key2) — Primary key — NOT NULL
  • Equipment Name (Key) — Foreign key → env_plc_cfg.Equipment Name — NOT NULL
  • Tag Name (Key22) — Foreign key → plc_tagset_info.Tag Name — NOT NULL
  • Value (Field)
  • Changed End Time (Field2)

filejob_tag_info (Untitled6)

  • Job ID (Key22) — Foreign key → env_filejob_cfg.Job ID — NOT NULL
  • Tag Name (Key2) — Foreign key → std_tag_info.Tag Name — NOT NULL
  • Tag Use (Field2)
  • History Save Flag (Field3)
  • Rule Name (Key23) — Foreign key → std_rule_info.Rule Name — NOT NULL

filejob_tag_param (Untitled7)

  • Depth Lvel (Key) — Primary key — NOT NULL
  • Option Key (Key3) — Primary key — NOT NULL
  • Job ID (Key22) — Foreign key → filejob_tag_info.Job ID — NOT NULL
  • Tag Name (Key2) — Foreign key → filejob_tag_info.Tag Name — NOT NULL
  • Option Value (Field)
  • Array Flag (Field2)

plc_tagset_info (Untitled3)

  • Set ID (Key3) — Primary key — NOT NULL
  • Sub ID (Key4) — Primary key — NOT NULL
  • Tag Name (Key2) — Foreign key → std_tag_info.Tag Name — NOT NULL
  • Tag Size (Field)
  • Sequence Number (Field2)
  • Tag Type (Field3)
  • Tag Use (Field5)
  • Client Message Send Flag (Field6)
  • Command Rule Name (Field7)
  • History Save Flag (Field8)
  • Tag Name (Key5) — NOT NULL
  • Rule Name (Key22) — Foreign key → std_rule_info.Rule Name — NOT NULL

plc_tagset_param (Untitled4)

  • PLC ID (Key2) — Foreign key → env_plc_cfg.PLC ID — NOT NULL
  • Set ID (Key3) — Foreign key → plc_tagset_info.Set ID — NOT NULL
  • Sub ID (Key4) — Foreign key → plc_tagset_info.Sub ID — NOT NULL
  • Tag Name (Key22) — Foreign key → plc_tagset_info.Tag Name — NOT NULL
  • Delay (Field)
  • Interval (Field2)
  • Address Offset (Field3)
  • Memory Address (Field4)

se_actor_cfg (Untitled9)

  • Actor ID (Key) — Primary key — NOT NULL
  • Child Actor Number (Key2) — Primary key — NOT NULL
  • Actor System ID (Key3) — Primary key — NOT NULL
  • Actor Class Name (Field)
  • Actor Router Count (Field2)
  • Actor Use Flag (Field3)
  • Parent Actor ID (Field4)
  • Parent Actor Class Name (Field5)

std_rule_info (Untitled8)

  • Rule Group Name (Key) — Primary key — NOT NULL
  • Rule Name (Key2) — Primary key — NOT NULL
  • Function Name (Key3) — Primary key — NOT NULL
  • Json Paramter (Field)

std_tag_info (Untitled5)

  • Tag Group Name (Key) — Primary key — NOT NULL
  • Tag Name (Key2) — Primary key — NOT NULL