wms_order_items

订单货品明细表(弃用)

所属应用: wms

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
item_id	item_id	int(10) unsigned	Y		N
obj_id	obj_id	int(10) unsigned	Y	0	N
product_id	product_id	int(10) unsigned	Y	0	N
bn	bn	varchar(40)	N		N
name	name	varchar(200)	N		N
price	price	decimal(20,3)	Y	0	N
pmt_price	pmt_price	decimal(20,3)	N	0	N
sale_price	sale_price	decimal(20,3)	N	0	N
nums	nums	mediumint(8) unsigned	Y	1	N
item_type	item_type	varchar(50)	Y	product	N

索引

Key name	Column names	Unique	Comment
primary	item_id	Y
idx_c_obj_id	obj_id	N
idx_c_product_id	product_id	N