sisdatabagclassify

资料袋操作明细(公共的)

• Engine: InnoDB
• Collation: utf8mb3_general_ci

Columns

#	Name	Type	Null	Key	Default	Extra	Comment
1	iIncrement	int	NO	PRI		auto_increment	自增列
2	sId	varchar(50)	NO	MUL			标准Id
3	sBrandsId	varchar(50)	NO	MUL			加工商Id
4	sSubsidiaryId	varchar(50)	NO				子公司ID
5	tCreateDate	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED	制单日期
6	iOrder	int	NO		0		排序号
7	sWorkOrderNo	varchar(50)	NO				工单号
8	sWorkOrderId	varchar(50)	NO				工单Id
9	sDatabagName	varchar(50)	YES				资料名称
10	dDatabagQty	decimal(18,6)	YES				数量
11	iFace	int	YES				印面
12	sMachineName	varchar(50)	YES				机器名称
13	sMachineId	varchar(50)	YES				机器Id
14	tPrintDate	datetime	YES				印刷时间
15	sStatus	varchar(1)	YES				状态
16	sMemo	longtext	YES				工作描述

Indexes

Name	Unique	Type	Columns
IndexN_2	✓	BTREE	sBrandsId, sSubsidiaryId, sWorkOrderId
IndexU_1	✓	BTREE	sId, sBrandsId, sSubsidiaryId
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.