ome_order_objects_extend
订单Objects扩展表
所属应用: ome
表结构
| ColumnName | Comment | Type | Not null | Default | Autoincrement |
|---|---|---|---|---|---|
| obj_id | 订单obj_id | int(10) unsigned | Y | 0 | N |
| order_id | order_id | int(10) unsigned | Y | 0 | N |
| store_dly_type | 门店发货模式 | tinyint(1) | N | 0 | N |
| store_bn | 门店编码 | varchar(20) | N | N | |
| customization | 商品定制信息,格式:json | longtext | 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 | obj_id | Y | |
| ind_at_time | at_time | N | |
| ind_up_time | up_time | N | |
| idx_c_order_id | order_id | N |
