| 字段 | 类型 | 键 | 可空 | 默认 | 注释 |
|---|---|---|---|---|---|
| id | char(36) | PRI | NO | ||
| type | longtext | YES | |||
| customer_id | char(36) | YES | |||
| worker_id | char(36) | YES | |||
| address | longtext | YES | |||
| distance | decimal(8,2) | YES | |||
| reward | decimal(10,2) | YES | |||
| match_rate | decimal(5,2) | YES | |||
| status | longtext | YES | |||
| is_urgent | tinyint(1) | YES | |||
| is_deleted | tinyint(1) | YES | |||
| created_at | datetime(3) | YES | |||
| updated_at | datetime(3) | YES | |||
| items | longtext | YES | |||
| requirements | longtext | YES | |||
| estimated_time | longtext | YES | |||
| scheduled_time | datetime(3) | YES | |||
| customer_name | varchar(100) | YES | |||
| customer_phone | varchar(20) | YES | |||
| rating | int(11) | YES | |||
| review | longtext | YES | |||
| review_reply | longtext | YES | |||
| order_no | varchar(50) | YES | |||
| service_type | varchar(100) | YES | |||
| service_date | date | YES | |||
| service_time | longtext | YES | |||
| duration | int(11) | YES | |||
| service_address | longtext | YES | |||
| latitude | decimal(10,7) | YES | |||
| longitude | decimal(10,7) | YES | |||
| notes | longtext | YES | |||
| completion_time | datetime(3) | YES | |||
| cancellation_reason | longtext | YES | |||
| review_time | datetime(3) | YES | |||
| payment_method | longtext | YES | |||
| payment_time | datetime(3) | YES |
| 索引名 | 字段 | 类型 |
|---|---|---|
| PRIMARY | id | 唯一 |
| id | type | customer_id | worker_id | address | distance | reward | match_rate | status | is_urgent | is_deleted | created_at |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 11a751dc-473b-5280-b54b-b73307363faf | service | 8ff30c1d-d0c1-409b-96ab-f5d0f4b16f98 | 8356f74a-8558-40de-b37a-29c7f3815dbf | 四川省成都市… | 1.20 | 80.00 | 88.00 | pending | 0 | 0 | 2026-11-09 04:48:31.553000 |
| 2be3ead0-6140-5a73-a035-4e14ab1d9453 | service | 8ff30c1d-d0c1-409b-96ab-f5d0f4b16f98 | 8356f74a-8558-40de-b37a-29c7f3815dbf | 四川省成都市… | 2.40 | 160.00 | 96.00 | cancelled | 0 | 0 | 2026-11-09 04:48:31.553000 |
| 38721da6-64f1-57c8-b82f-9dc9c252f88a | service | 8ff30c1d-d0c1-409b-96ab-f5d0f4b16f98 | 8356f74a-8558-40de-b37a-29c7f3815dbf | 四川省成都市… | 1.80 | 120.00 | 92.00 | completed | 0 | 0 | 2026-11-09 04:48:31.553000 |