elematerialssafe

安全库存

• 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	sMakePerson	varchar(50)	NO				制单人
7	iOrder	int	NO		0		排序号
8	sMaterialsId	varchar(50)	NO	MUL			材料ID
9	sMaterialsStyle	varchar(50)	NO				材料规格
10	sPackStyle	varchar(50)	YES				包装规格
11	sAuxiliaryUnit	varchar(50)	NO				库存单位
12	dMinStock	decimal(18,6)	YES		0.000000		最小库存换算数量
13	dMaxStock	decimal(18,6)	YES		0.000000		最大库存换算数量
14	dMinStockAuxiliaryQty	decimal(18,6)	YES		0.000000		最小库存
15	dMaxStockAuxiliaryQty	decimal(18,6)	YES		0.000000		最大库存
16	sCReserve1	varchar(50)	YES				预留字符1
17	sCReserve2	varchar(50)	YES				预留字符2
18	sCReserve3	varchar(50)	YES				预留字符3
19	dCReserve1	decimal(18,6)	YES				预留数字1
20	dCReserve2	decimal(18,6)	YES				预留数字2
21	dCReserve3	decimal(18,6)	YES				预留数字3
22	iCReserve1	int	YES				预留整型1
23	iCReserve2	int	YES				预留整型2
24	iCReserve3	int	YES				预留整型3
25	tCReserve1	datetime	YES				预留日期1
26	tCReserve2	datetime	YES				预留日期2
27	tCReserve3	datetime	YES				预留日期3
28	tMakeDate	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED	制单日期
29	iMaxpurday	int	YES				最高采购周期
30	iMixpurday	int	YES				最低采购周期
31	sHeight1	varchar(50)	YES				材料高
32	sLength1	varchar(50)	YES				材料长
33	sSafeMemo	text	YES				备注
34	sSlaveOldMaterialsNo	varchar(50)	YES				旧代码
35	sWidth1	varchar(50)	YES				材料宽

Indexes

Name	Unique	Type	Columns
IndexN_10		BTREE	sMaterialsId, sBrandsId, sSubsidiaryId
IndexN_elematerialsstock		BTREE	sId, sBrandsId, sSubsidiaryId
IndexU_elematerialsstock	✓	BTREE	sId, sBrandsId, sSubsidiaryId
IndexU_elematerialsstockId	✓	BTREE	sBrandsId, sSubsidiaryId, sMaterialsId, sMaterialsStyle
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.