sysdoplclog

• Rows (estimated): 0
• Data size: 16.0 KB
• Engine: InnoDB
• Collation: utf8mb4_general_ci
• Created: 2026-04-27 18:57:09
• Updated:

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.