salsalesordermakeupslave

拼版任务从表

• 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				加工商ID
4	sSubsidiaryId	varchar(50)	NO				子公司ID
5	iOrder	int	NO		0		排序号
6	sMakePerson	varchar(50)	NO				制单人
7	sParentId	varchar(50)	NO	MUL			父节点ID
8	tCreateDate	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED	记账日期
9	sOrderId	varchar(50)	NO	MUL			父节点ID
10	sOrderNo	varchar(50)	NO				父节点ID
11	sOrderSlaveId	varchar(50)	NO	MUL			订单ID
12	sProductId	varchar(50)	NO				产品ID
13	sProductName	varchar(100)	NO				产品名称
14	sProductNo	varchar(50)	NO				产品编号
15	dProductQty	decimal(18,6)	NO		0.000000		产品数量
16	dCombineQty	decimal(18,6)	NO		0.000000		合拼排版数
17	dFactProductQty	decimal(18,6)	NO		0.000000		实际生产数
18	sYsProcessId	varchar(50)	NO				印刷工序ID
19	sYsProcessName	varchar(100)	NO				印刷工序名称
20	sYsProcessNo	varchar(50)	NO				印刷工序名称
21	sPageMaterialsId	varchar(50)	NO				纸张ID
22	sPageMaterialsName	varchar(100)	NO				纸张名称
23	sPageMaterialsNo	varchar(50)	NO				纸张编号
24	sMakeUpPath	varchar(50)	NO		0		拼版PDF
25	sCustomerId	varchar(50)	NO		0		客户ID
26	sCustomerName	varchar(100)	NO		0		客户名称
27	sProductStyle	varchar(50)	NO				印品规格

Indexes

Name	Unique	Type	Columns
IndexU_1	✓	BTREE	sId, sBrandsId, sSubsidiaryId
IndexU_2		BTREE	sParentId
IndexU_3		BTREE	sOrderId
IndexU_4		BTREE	sOrderSlaveId
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.