plc_machineaddrmap.md 1.22 KB

plc_machineaddrmap

  • Engine: InnoDB
  • Collation: utf8mb3_general_ci

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 加工商ID
4 sSubsidiaryId varchar(100) NO 子公司ID
5 sMachineNo varchar(255) NO MUL 设备编号
6 iOrder int NO 0 序号
7 sPlcsStatusName varchar(255) NO 名称
8 iPlcsStatusAdd int NO 0 地址
9 iType int NO 0 1:班组 2:工单 3:后续工单;0:不写入PLC;4: 需要写入PLC的INT
10 dMin decimal(18,1) NO 0.0 最小值
11 dMax decimal(18,1) NO 0.0 最大值

Indexes

Name Unique Type Columns
sMachineNo BTREE sMachineNo
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.