ome_order_pmt

订单促销规则

所属应用: ome

表结构

ColumnName	Comment	Type	Not null	Default	Autoincrement
id	id	int(10) unsigned	Y		Y
order_id	order_id	int(10) unsigned	Y		N
pmt_amount	pmt_amount	decimal(20,3)	N		N
pmt_memo	pmt_memo	longtext	N		N
pmt_describe	pmt_describe	longtext	N		N
coupon_id	优惠券ID	varchar(32)	N		N
up_time	更新时间	TIMESTAMP	N	CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP	N

索引

Key name	Column names	Unique	Comment
primary	id	Y
ind_up_time	up_time	N
idx_c_order_id	order_id	N