| 字段 | 类型 | 键 | 可空 | 默认 | 注释 |
|---|---|---|---|---|---|
| id | char(36) | PRI | NO | ||
| merchant_id | char(36) | MUL | YES | ||
| name | varchar(128) | YES | |||
| code | varchar(32) | YES | |||
| type | tinyint(4) | YES | 0 | 0中心仓 1门店前置仓 2第三方仓 | |
| address | longtext | YES | |||
| contact_name | varchar(64) | YES | |||
| contact_phone | varchar(32) | YES | |||
| area_m2 | decimal(12,2) | YES | |||
| status | tinyint(4) | YES | 1 | ||
| is_deleted | tinyint(1) | YES | 0 | ||
| created_at | datetime(3) | YES | |||
| updated_at | datetime(3) | YES |
| 索引名 | 字段 | 类型 |
|---|---|---|
| idx_wh_merchant | merchant_id,status | 普通 |
| PRIMARY | id | 唯一 |
| uk_wh_code | merchant_id,code | 普通 |
| id | merchant_id | name | code | type | address | contact_name | contact_phone | area_m2 | status | is_deleted | created_at |
|---|---|---|---|---|---|---|---|---|---|---|---|
| wh-0001-0000-4000-8000-000000000001 | de000063-1000-4000-8000-000000000003 | 云届优选粮油-翠湖前置仓 | WH-CH-01 | 1 | 遵义市红花岗… | 李** | 138****0001 | NULL | 1 | 0 | 2026-11-07 09:09:08.298000 |
| wh-0002-0000-4000-8000-000000000002 | de000063-1000-4000-8000-000000000001 | 云届社区旗舰店-前置仓 | WH-QJ-01 | 1 | 遵义市汇川区… | 王** | 139****0002 | NULL | 1 | 0 | 2026-11-07 09:09:08.298000 |
| wh-0003-0000-4000-8000-000000000003 | d86ba3a1-c8aa-495e-9d1f-af5a495e4172 | 贵州云届-中心仓 | WH-ZY-00 | 0 | 遵义市播州区… | 张** | 138****0005 | NULL | 1 | 0 | 2026-11-07 09:09:08.298000 |