| 字段 | 类型 | 键 | 可空 | 默认 | 注释 |
|---|---|---|---|---|---|
| id | char(36) | PRI | NO | ||
| user_id | char(36) | YES | |||
| total_amount | decimal(12,2) | YES | |||
| discount_amount | decimal(12,2) | YES | |||
| delivery_fee | decimal(10,2) | YES | |||
| final_amount | decimal(12,2) | YES | |||
| status | longtext | YES | |||
| delivery_type | longtext | YES | |||
| address | longtext | YES | |||
| store_id | char(36) | YES | |||
| blockchain_tx_hash | longtext | YES | |||
| is_deleted | tinyint(1) | YES | |||
| created_at | datetime(3) | YES | |||
| updated_at | datetime(3) | YES | |||
| order_no | varchar(50) | UNI | YES | ||
| customer_name | varchar(100) | YES | |||
| customer_phone | varchar(20) | YES | |||
| payment_method | longtext | YES | |||
| payment_time | datetime(3) | YES | |||
| completed_time | datetime(3) | YES | |||
| cancelled_time | datetime(3) | YES | |||
| cancel_reason | longtext | YES | |||
| tracking_number | varchar(100) | YES | |||
| logistics_company | varchar(100) | YES | |||
| coupon_amount | decimal(10,2) | YES | |||
| points_used | int(11) | YES | |||
| remark | longtext | YES | |||
| source | longtext | YES | |||
| promoter_id | char(36) | YES | |||
| merchant_id | char(36) | YES | |||
| refund_amount | decimal(12,2) | YES | |||
| refunded_at | datetime(3) | YES | |||
| refund_reason | longtext | YES | |||
| pickup_time | datetime(3) | YES | |||
| is_test | tinyint(1) | NO | 0 | 1=测试造数 |
| 索引名 | 字段 | 类型 |
|---|---|---|
| PRIMARY | id | 唯一 |
| uk_orders_order_no | order_no | 普通 |
| id | user_id | total_amount | discount_amount | delivery_fee | final_amount | status | delivery_type | address | store_id | blockchain_tx_hash | is_deleted |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 04975f48-68fc-5ab2-8fae-cfa87810e12f | 5f56da1c-8699-4c29-afc2-8f9bccd11c41 | 25.36 | 0.00 | 4.00 | 29.36 | paid | delivery | 四川省成都市… | 4ad3efb6-6913-4a67-af89-5304861bf08e | NULL | 0 |
| 1e207368-f050-51c4-91a2-1f4317e467b0 | 0da15089-2a5b-4222-bc11-95990ae1c9c5 | 113.40 | 0.00 | 0.00 | 113.40 | created | delivery | 四川省成都市… | 4ad3efb6-6913-4a67-af89-5304861bf08e | NULL | 0 |
| 279e0d8d-5b19-5e95-b5a3-5e95690d6d57 | 8ff30c1d-d0c1-409b-96ab-f5d0f4b16f98 | 15.14 | 0.00 | 4.00 | 19.14 | completed | delivery | 四川省成都市… | 4ad3efb6-6913-4a67-af89-5304861bf08e | NULL | 0 |