o2o_branch_product
门店供货关系表
所属应用: o2o
表结构
| ColumnName | Comment | Type | Not null | Default | Autoincrement |
|---|---|---|---|---|---|
| id | id | mediumint(8) unsigned | Y | Y | |
| branch_id | branch_id | mediumint(8) unsigned | Y | N | |
| bm_id | bm_id | int(10) unsigned | Y | N | |
| is_ctrl_store | 库存 | tinyint(1) | N | 2 | N |
| status | 销售状态 | tinyint(1) | N | 1 | N |
| is_bind | 绑定状态 | tinyint(1) | N | 1 | N |
索引
| Key name | Column names | Unique | Comment |
|---|---|---|---|
| primary | id | Y | |
| ind_branch_id_bm_id | branch_id, bm_id | Y | |
| idx_c_branch_id | branch_id | N | |
| idx_c_bm_id | bm_id | N |