brush_delivery_items_detail

---

所属应用: brush

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
item_detail_id	item_detail_id	int(10) unsigned	Y		Y
delivery_id	delivery_id	int(10) unsigned	Y		N
delivery_item_id	delivery_item_id	int(10) unsigned	Y		N
order_id	order_id	int(10) unsigned	Y		N
order_item_id	order_item_id	int(10) unsigned	Y		N
order_obj_id	order_obj_id	int(10) unsigned	Y		N
item_type	item_type product:商品;gift:赠品;pkg:捆绑商品;adjunct:配件;	enum('product','gift','pkg','adjunct')	Y	product	N
product_id	product_id	int(10) unsigned	Y		N
bn	bn	varchar(30)	N		N
number	number	mediumint(8) unsigned	Y		N
price	平均单价	decimal(20,3)	Y	0	N
amount	amount	decimal(20,3)	Y	0	N

索引

Key name	Column names	Unique	Comment
primary	item_detail_id	Y
ind_delivery_item_id	delivery_item_id	N
ind_order_item_id	order_item_id	N
ind_order_obj_id	order_obj_id	N
idx_c_delivery_id	delivery_id	N
idx_c_order_id	order_id	N
idx_c_product_id	product_id	N