archive_delivery_items_detail

归档发货单明细关联订单表

所属应用: archive

表结构

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	订单号ID	int(10) unsigned	Y		N
order_item_id	订单商品明细ID	int(10) unsigned	Y		N
order_obj_id	订单商品对象ID	int(10) unsigned	Y		N
item_type	item_type product:商品;gift:赠品;pkg:捆绑商品;adjunct:配件;lkb:福袋;pko:多选一;	enum('product','gift','pkg','adjunct','lkb','pko')	Y	product	N
product_id	货号ID	int(10) unsigned	Y		N
bn	货号	varchar(30)	N		N
number	数量	mediumint(8) unsigned	Y		N
price	单价	decimal(20,3)	Y	0	N
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_product_id	product_id	N