brush_delivery_items

---

所属应用: brush

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
item_id	item_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
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

索引

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