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