| 字段 | 类型 | 键 | 可空 | 默认 | 注释 |
|---|---|---|---|---|---|
| id | char(36) | PRI | NO | ||
| user_id | char(36) | YES | |||
| name | varchar(100) | YES | |||
| phone | varchar(20) | YES | |||
| skills | longtext | YES | |||
| rating | decimal(2,1) | YES | |||
| completed_orders | int(11) | YES | |||
| credit_level | int(11) | YES | |||
| status | longtext | YES | |||
| is_deleted | tinyint(1) | YES | |||
| created_at | datetime(3) | YES | |||
| updated_at | datetime(3) | YES | |||
| real_name | longtext | YES | |||
| id_card_front | longtext | YES | |||
| id_card_back | longtext | YES | |||
| service_type | longtext | YES | |||
| skills_description | longtext | YES | |||
| cert_images | longtext | YES | |||
| review_status | longtext | YES | |||
| review_remark | longtext | YES | |||
| reviewed_by | char(36) | YES | |||
| reviewed_at | datetime(3) | YES | |||
| avatar | longtext | YES | |||
| id_card | longtext | YES | |||
| work_experience | int(11) | YES | |||
| service_area | varchar(500) | YES | |||
| latitude | decimal(10,7) | YES | |||
| longitude | decimal(10,7) | YES | |||
| available_hours | longtext | YES | |||
| total_earnings | decimal(12,2) | YES | |||
| month_earnings | decimal(12,2) | YES | |||
| response_time | int(11) | YES | |||
| acceptance_rate | decimal(5,2) | YES | |||
| complaint_count | int(11) | YES | |||
| verification_status | longtext | YES | |||
| bank_account | longtext | YES | |||
| bank_name | longtext | YES | |||
| emergency_contact | longtext | YES | |||
| emergency_phone | longtext | YES | |||
| review_history | longtext | YES | |||
| service_items | longtext | YES | |||
| claim_status | varchar(20) | YES | 账号认领状态 pending_claim=待认领 |
| 索引名 | 字段 | 类型 |
|---|---|---|
| PRIMARY | id | 唯一 |
| id | user_id | name | phone | skills | rating | completed_orders | credit_level | status | is_deleted | created_at | updated_at |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 045801c3-d1db-58cb-87a6-1cd809b02335 | NULL | 曾明 | 139****0085 | 4.9 | 311 | 2 | online | 0 | 2026-11-07 11:45:13.916000 | 2026-11-07 11:45:13.916000 | |
| 04a52d62-89d8-4587-b55b-4efb1b792bbc | NULL | 梁萍 | 139****4518 | 洗衣洗护 | 4.7 | 166 | 4 | active | 0 | 2026-11-07 12:26:48.850000 | 2026-11-07 12:26:48.850000 |
| 051b21a4-d985-4cd1-8131-d35141ac34e3 | NULL | 郭红军 | 139****6661 | 消杀除虫 | 4.7 | 242 | 5 | active | 0 | 2026-11-07 12:26:48.753000 | 2026-11-07 12:26:48.753000 |