sysdoplclog.md 1012 Bytes

sysdoplclog

  • Engine: InnoDB
  • Collation: utf8mb4_general_ci

Columns

# Name Type Null Key Default Extra Comment
1 iIncrement int NO 0 自增列
2 sId varchar(100) NO 标准Id
3 tCreateDate datetime NO CURRENT_TIMESTAMP DEFAULT_GENERATED 制单日期
4 iSemens int YES 中控号
5 sPlcAddr longtext YES 中控IP地址
6 sSql longtext YES 执行sSql
7 sValues longtext YES 执行值
8 sReason longtext YES 执行结果
9 sExeType varchar(50) NO 3 执行状态({"1":"连接PLC失败","2":"访问PLC权限不足","3":"正常运行","4":"插入数据库失败"})

Narrative

No human-written narrative yet — when this table is exercised by a vertical slice, link from there back to this page.