| 字段 | 类型 | 键 | 可空 | 默认 | 注释 |
|---|---|---|---|---|---|
| id | char(36) | PRI | NO | ||
| user_id | char(36) | YES | |||
| order_no | longtext | YES | |||
| items | longtext | YES | |||
| product_count | int(11) | YES | |||
| total_quantity | int(11) | YES | |||
| total_cost | decimal(12,2) | YES | |||
| estimated_profit | decimal(12,2) | YES | |||
| remark | longtext | YES | |||
| is_deleted | tinyint(1) | YES | |||
| created_at | datetime(3) | YES | |||
| updated_at | datetime(3) | YES | |||
| store_id | char(36) | YES | |||
| store_name | longtext | YES | |||
| status | longtext | YES | |||
| payment_method | longtext | YES | |||
| paid_at | datetime(3) | YES | |||
| completed_at | datetime(3) | YES | |||
| pay_note | longtext | YES | |||
| return_reason | longtext | YES | |||
| return_note | longtext | YES | |||
| return_quantity | decimal(12,2) | YES | |||
| return_requested_at | datetime(3) | YES | |||
| returned_at | datetime(3) | YES | |||
| return_from_status | longtext | YES | |||
| return_reviewed_by | char(36) | YES |
| 索引名 | 字段 | 类型 |
|---|---|---|
| PRIMARY | id | 唯一 |
| id | user_id | order_no | items | product_count | total_quantity | total_cost | estimated_profit | remark | is_deleted | created_at | updated_at |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 375b0a27-8b6c-5b97-bf05-baaa4751e3c2 | 8ff30c1d-d0c1-409b-96ab-f5d0f4b16f98 | CG20261109001 | [{"productId": "0000d2f3-1978-4e23-aa87-b4… | 1 | 15 | 117.22 | 46.89 | 补货 | 0 | 2026-11-09 04:48:31.553000 | 2026-11-09 04:48:31.553000 |
| 610bb0c6-00d4-593a-9365-a3e8837d6e25 | 8ff30c1d-d0c1-409b-96ab-f5d0f4b16f98 | CG20261109003 | [{"productId": "0003cbbf-9d90-44bc-bdef-b6… | 1 | 39 | 272.82 | 109.13 | 补货 | 0 | 2026-11-09 04:48:31.553000 | 2026-11-09 04:48:31.553000 |
| adc1aeae-307c-5b54-8101-87202e0e2321 | 8ff30c1d-d0c1-409b-96ab-f5d0f4b16f98 | CG20261109002 | [{"productId": "00025b95-27f3-4786-b76f-bf… | 1 | 26 | 191.99 | 76.80 | 补货 | 0 | 2026-11-09 04:48:31.553000 | 2026-11-09 04:48:31.553000 |