logistics_rule_shop
优选规则与店铺关系表
所属应用: logistics
表结构
| ColumnName | Comment | Type | Not null | Default | Autoincrement |
|---|---|---|---|---|---|
| id | id | mediumint(8) unsigned | Y | Y | |
| rule_id | rule_id | int(10) unsigned | Y | N | |
| shop_id | shop_id | varchar(32) | Y | N | |
| branch_id | branch_id | mediumint(8) unsigned | Y | N |
索引
| Key name | Column names | Unique | Comment |
|---|---|---|---|
| primary | id | Y | |
| ind_rule_id_shop_id | rule_id, shop_id | Y | |
| idx_c_rule_id | rule_id | N | |
| idx_c_shop_id | shop_id | N | |
| idx_c_branch_id | branch_id | N |