wms_delivery_items_storage_life

发货单明细预占保质期信息

所属应用: wms

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
itemsl_id	itemsl_id	int(10) unsigned	Y		Y
item_id	item_id	int(10) unsigned	Y		N
delivery_id	delivery_id	int(10) unsigned	Y		N
bm_id	bm_id	int(10) unsigned	Y		N
bn	bn	varchar(30)	N		N
product_name	product_name	varchar(200)	N		N
expire_bn	expire_bn	varchar(200)	Y		N
number	number	mediumint(8) unsigned	Y	0	N
verify	verify	enum('true','false')	Y	false	N
verify_num	verify_num	mediumint(8) unsigned	Y	0	N

索引

Key name	Column names	Unique	Comment
primary	itemsl_id	Y