archive_order_pmt
归档订单促销规则
所属应用: archive
表结构
| ColumnName | Comment | Type | Not null | Default | Autoincrement |
|---|---|---|---|---|---|
| id | id | int(10) unsigned | Y | Y | |
| order_id | 订单ID | int(10) unsigned | Y | N | |
| pmt_amount | 促销金额 | decimal(20,3) | N | N | |
| pmt_memo | 促销备注 | longtext | N | N | |
| pmt_describe | 促销描述 | longtext | N | N | |
| coupon_id | 优惠券ID | varchar(32) | N | N | |
| up_time | 更新时间 | TIMESTAMP | N | CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP | N |
| archive_time | 归档时间 | int(10) unsigned | N | N |
索引
| Key name | Column names | Unique | Comment |
|---|---|---|---|
| primary | id | Y | |
| ind_up_time | up_time | N | |
| ind_order_id | order_id | N | |
| ind_archive_time | archive_time | N |