| 字段 | 类型 | 键 | 可空 | 默认 | 注释 |
|---|---|---|---|---|---|
| id | char(36) | PRI | NO | ||
| delivery_id | char(36) | MUL | YES | ||
| delivery_no | varchar(64) | YES | |||
| status | varchar(32) | YES | accepted/picked/onway/arrived/failed | ||
| location_lat | decimal(10,6) | YES | |||
| location_lng | decimal(10,6) | YES | |||
| address_text | longtext | YES | |||
| operator_id | char(36) | YES | |||
| operator_name | varchar(64) | YES | |||
| remark | longtext | YES | |||
| created_at | datetime(3) | YES |
| 索引名 | 字段 | 类型 |
|---|---|---|
| idx_dt_delivery | delivery_id,created_at | 普通 |
| PRIMARY | id | 唯一 |
| id | delivery_id | delivery_no | status | location_lat | location_lng | address_text | operator_id | operator_name | remark | created_at |
|---|---|---|---|---|---|---|---|---|---|---|
| 19f9f6fe-c861-4673-a684-de3cd86e1a96 | b014fffa-5021-4756-940c-7c6d588541f7 | NULL | picked | NULL | NULL | NULL | rider01 | NULL | NULL | 2026-11-07 09:19:22.356000 |
| 261a7f88-fe96-4ee9-9fd2-5d3282740d09 | 72d4ee12-734a-4582-8664-e40441c9da11 | NULL | picked | NULL | NULL | NULL | rider01 | NULL | NULL | 2026-11-07 09:21:20.285000 |
| 398e9953-eda1-5ed2-90af-4550f9767310 | 0e4ee13e-6558-573d-935d-8947dcc47d46 | DL20261109002 | pickup | 30.500000 | 104.060000 | 四川省成都市… | cdb248cb-42de-4fbd-b9c5-1f10124e84ea | 骑手小周 | 节点:已取货 | 2026-11-09 03:48:31.553000 |