wap_delivery_items

移动端发货通知单明细表

所属应用: wap

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
item_id	item_id	int(10) unsigned	Y		Y
outer_item_id	outer_item_id	int(10) unsigned	Y		N
delivery_id	delivery_id	int(10) unsigned	Y	0	N
product_id	product_id	int(10) unsigned	Y	0	N
shop_product_id	shop_product_id	varchar(50)	N		N
bn	bn	varchar(30)	N		N
product_name	product_name	varchar(200)	N		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
price	price	decimal(20,3)	Y	0	N
sale_price	sale_price	decimal(20,3)	Y	0	N
pmt_price	pmt_price	decimal(20,3)	Y	0	N

索引

Key name	Column names	Unique	Comment
primary	item_id	Y
idx_c_delivery_id	delivery_id	N
idx_c_product_id	product_id	N