wms_delivery_items_serial

发货单货品唯一码表

所属应用: wms

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
item_serial_id	item_serial_id	int(10) unsigned	Y		Y
delivery_id	delivery_id	int(10) unsigned	Y	0	N
product_id	product_id	int(10) unsigned	Y	0	N
bn	bn	varchar(30)	N		N
product_name	product_name	varchar(200)	N		N
serial_id	serial_id	int(10) unsigned	Y	0	N
serial_number	唯一码	varchar(30)	Y		N
status	状态	tinyint(1)	Y	0	N

索引

Key name	Column names	Unique	Comment
primary	item_serial_id	Y
idx_c_serial_number	serial_number	N
idx_c_delivery_id	delivery_id	N
idx_c_product_id	product_id	N
idx_c_serial_id	serial_id	N