omeanalysts_ome_salestatistics

退货率统计

所属应用: omeanalysts

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
record_id	record_id	mediumint(8) unsigned	Y		Y
shop_id	店铺ID	varchar(32)	N		N
shop_bn	店铺编码	varchar(20)	N		N
shop_name	店铺名称	varchar(255)	N		N
shop_type	店铺类型	varchar(50)	N		N
day	发货时间	int(10) unsigned	N		N
order_num	当日下单量	mediumint(8) unsigned	N		N
order_amount	当日下单金额	decimal(20,3)	N		N
delivery_num	当日发货量	mediumint(8) unsigned	N		N
delivery_amount	当日发货金额	decimal(20,3)	N		N
delivery_return_num	发货退货量	mediumint(8) unsigned	N		N
delivery_return_amount	发货退货金额	decimal(20,3)	N		N
return_num	当日退货量	mediumint(8) unsigned	N		N
return_amount	当日退货金额	decimal(20,3)	N		N
at_time	创建时间	TIMESTAMP	N	CURRENT_TIMESTAMP	N
up_time	更新时间	TIMESTAMP	N	CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP	N

索引

Key name	Column names	Unique	Comment
primary	record_id	Y
ind_day	day	N
ind_shop_id	shop_id	N
ind_at_time	at_time	N
ind_up_time	up_time	N