ome_order_abnormal
订单异常表
所属应用: ome
表结构
| ColumnName | Comment | Type | Not null | Default | Autoincrement |
|---|---|---|---|---|---|
| aid | aid | int(10) unsigned | Y | Y | |
| order_id | 订单ID | int(10) unsigned | Y | 0 | N |
| abnormal_type | 异常类型 | varchar(30) | N | N | |
| abnormal_msg | 异常信息 | text | N | N | |
| at_time | 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 | aid | Y | |
| ind_abnormal_type | abnormal_type | N | |
| ind_order_abnormal | order_id, abnormal_type | N | |
| ind_at_time | at_time | N | |
| ind_up_time | up_time | N | |
| idx_c_order_id | order_id | N |