ome_sales_items_props
所属应用: ome
表结构
| ColumnName | Comment | Type | Not null | Default | Autoincrement |
|---|---|---|---|---|---|
| id | 自增ID | int(10) unsigned | N | Y | |
| item_detail_id | 明细ID | int(10) unsigned | N | N | |
| props_col | 键名 | varchar(255) | N | N | |
| props_value | 键值 | varchar(255) | 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 | id | Y | |
| idx_at_time | at_time | N | |
| idx_up_time | up_time | N | |
| idx_c_item_detail_id | item_detail_id | N |