ome_goods_spec_index
商品规格索引表
所属应用: ome
表结构
| ColumnName | Comment | Type | Not null | Default | Autoincrement |
|---|---|---|---|---|---|
| type_id | type_id | mediumint(8) unsigned | Y | 0 | N |
| spec_id | spec_id | mediumint(8) unsigned | Y | 0 | N |
| spec_value_id | spec_value_id | mediumint(8) unsigned | Y | 0 | N |
| goods_id | goods_id | int(10) unsigned | Y | 0 | N |
| product_id | product_id | int(10) unsigned | Y | 0 | N |
索引
| Key name | Column names | Unique | Comment |
|---|---|---|---|
| primary | spec_value_id, product_id | Y | |
| idx_c_type_id | type_id | N | |
| idx_c_spec_id | spec_id | N | |
| idx_c_goods_id | goods_id | N |