| 字段 | 类型 | 键 | 可空 | 默认 | 注释 |
|---|---|---|---|---|---|
| id | char(36) | PRI | NO | ||
| delivery_no | varchar(64) | UNI | YES | 配送单号 | |
| order_id | char(36) | MUL | YES | ||
| order_no | varchar(64) | YES | |||
| store_id | char(36) | MUL | YES | ||
| merchant_id | char(36) | YES | |||
| delivery_type | varchar(32) | YES | self | self自营/rider骑手/express快递/pickup自提 | |
| receiver_name | varchar(64) | YES | |||
| receiver_phone | varchar(32) | YES | |||
| receiver_address | longtext | YES | |||
| distance_km | decimal(8,2) | YES | |||
| fee | decimal(12,2) | YES | 0.00 | ||
| rider_id | char(36) | MUL | YES | ||
| rider_name | varchar(64) | YES | |||
| status | tinyint(4) | YES | 0 | 0待接单 1已接单 2配送中 3已送达 4异常 5已取消 | |
| accept_at | datetime(3) | YES | |||
| pickup_at | datetime(3) | YES | |||
| delivered_at | datetime(3) | YES | |||
| exception_reason | longtext | YES | |||
| remark | longtext | YES | |||
| is_deleted | tinyint(1) | YES | 0 | ||
| created_at | datetime(3) | YES | |||
| updated_at | datetime(3) | YES |
| 索引名 | 字段 | 类型 |
|---|---|---|
| idx_do_order | order_id | 普通 |
| idx_do_rider | rider_id,status | 普通 |
| idx_do_store | store_id,status | 普通 |
| PRIMARY | id | 唯一 |
| uk_delivery_no | delivery_no | 普通 |
| id | delivery_no | order_id | order_no | store_id | merchant_id | delivery_type | receiver_name | receiver_phone | receiver_address | distance_km | fee |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0e4ee13e-6558-573d-935d-8947dcc47d46 | DL20261109002 | 3e83dd8b-f5ed-53f7-9fa6-6014c8929058 | YJDEMO20261109002 | 4ad3efb6-6913-4a67-af89-5304861bf08e | de000063-1000-4000-8000-000000000003 | delivery | 普通用户小李 | 138****0002 | 四川省成都市… | 1.90 | 5.50 |
| 1e770a55-7b15-4aa2-8131-64c99a7348fd | DLSEED2026110901 | NULL | YJSEED2026110901 | 4ad3efb6-6913-4a67-af89-5304861bf08e | de000063-1000-4000-8000-000000000003 | instant | 普通用户小李 | 138****0002 | 四川省成都市… | 2.40 | 3.00 |
| 3ace4416-8a66-4152-a2eb-1a520744f11c | DLSEED2026110902 | NULL | YJSEED2026110902 | 4ad3efb6-6913-4a67-af89-5304861bf08e | de000063-1000-4000-8000-000000000003 | instant | 普通用户小李 | 138****0002 | 四川省成都市… | 2.40 | 3.00 |