plc_currentmachinevalue

税率设置

• Rows (estimated): 55
• Data size: 16.0 KB
• Engine: InnoDB
• Collation: utf8mb3_general_ci
• Created: 2026-04-27 18:54:56
• Updated: 2026-04-27 18:54:56

Columns

#	Name	Type	Null	Key	Default	Extra	Comment
1	iIncrement	int	NO	PRI		auto_increment	自增列
2	sId	varchar(100)	NO				标准ID
3	sBrandsId	varchar(100)	NO	MUL			加工商ID
4	sSubsidiaryId	varchar(100)	NO				子公司ID
5	iOrder	int	NO		0		排序号
6	sPlcsStatusName	varchar(255)	NO				名称
7	iPlcsStatusAdd	int	NO		0		地址
8	sPlcsStatusValue	varchar(255)	NO				值
9	iType	int	NO		0		1:班组 2:工单 3:后续工单；0：不写入PLC;4: 需要写入PLC的FLOAT 5:写INT
10	sParentId	varchar(255)	NO	MUL			父类编号
11	dMin	decimal(18,1)	NO		0.0		最小值
12	dMax	decimal(18,1)	NO		100.0		最大值
13	sMakePerson	varchar(100)	NO				制单人
14	tUpdate	datetime	YES			on update CURRENT_TIMESTAMP
15	sMachineType	varchar(50)	NO		machine		类型：machine:机器,shop：温度传感
16	iSemens	int	NO		0
17	iDbName	int	NO		0		DB名称
18	sIp	varchar(50)	YES				IP地址

Indexes

Name	Unique	Type	Columns
sBrandsId`, `sSubsidiaryId`, `iType		BTREE	sBrandsId, sSubsidiaryId, iType
sParentId`, `iOrder		BTREE	sParentId, iOrder
PRIMARY	✓	BTREE	iIncrement

Narrative

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