| 字段 | 类型 | 键 | 可空 | 默认 | 注释 |
|---|---|---|---|---|---|
| id | char(36) | PRI | NO | ||
| member_id | char(36) | YES | |||
| user_id | char(36) | YES | |||
| type | longtext | YES | |||
| amount | decimal(12,2) | YES | |||
| balance_before | decimal(12,2) | YES | |||
| balance_after | decimal(12,2) | YES | |||
| order_no | longtext | YES | |||
| remark | longtext | YES | |||
| operator_id | char(36) | YES | |||
| is_deleted | tinyint(1) | YES | |||
| created_at | datetime(3) | YES | |||
| updated_at | datetime(3) | YES | |||
| record_kind | longtext | YES | |||
| out_trade_no | longtext | YES | |||
| channel | longtext | YES | |||
| status | longtext | YES | |||
| gateway_trade_no | longtext | YES | |||
| paid_at | datetime(3) | YES | |||
| fail_reason | longtext | YES | |||
| transaction_id | char(36) | YES | |||
| member_recharge_status | longtext | YES | |||
| fee_type | longtext | YES | |||
| promoter_id | char(36) | YES | |||
| fee_started_at | datetime(3) | YES | |||
| fee_expires_at | datetime(3) | YES | |||
| gift_package_snapshot | longtext | YES |
| 索引名 | 字段 | 类型 |
|---|---|---|
| PRIMARY | id | 唯一 |
| id | member_id | user_id | type | amount | balance_before | balance_after | order_no | remark | operator_id | is_deleted | created_at |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 556fcec4-d259-4635-919d-bc44531e566e | 8ff30c1d-d0c1-409b-96ab-f5d0f4b16f98 | 8ff30c1d-d0c1-409b-96ab-f5d0f4b16f98 | consume | -58.90 | 700.00 | 641.10 | NULL | 订单消费 | NULL | 0 | 2026-11-01 12:00:00 |
| a1d1217a-d40d-4067-9c9b-e90c5ca93285 | 8ff30c1d-d0c1-409b-96ab-f5d0f4b16f98 | 8ff30c1d-d0c1-409b-96ab-f5d0f4b16f98 | refund | 15.90 | 641.10 | 657.00 | NULL | 订单退款返还 | NULL | 0 | 2026-11-02 12:00:00 |
| e19ef77c-4ee0-4393-93c0-bfb6fb605fd7 | 8ff30c1d-d0c1-409b-96ab-f5d0f4b16f98 | 8ff30c1d-d0c1-409b-96ab-f5d0f4b16f98 | recharge | 500.00 | 0.00 | 500.00 | NULL | 微信充值 | NULL | 0 | 2026-10-30 12:00:00 |