| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| id | bigint | PRI | NO | |
| source_site | varchar | — | NO | |
| out_trade_no | varchar | UNI | NO | 小芸侧交易号 |
| transaction_id | varchar | — | YES | |
| open_id | varchar | — | YES | |
| amount | decimal | — | YES | |
| trade_state | varchar | MUL | YES | SUCCESS/REFUND/NOTPAY... |
| pay_channel | varchar | — | YES | |
| biz_type | varchar | — | YES | order/service/other |
| payload | json | — | YES | |
| occurred_at | datetime | — | YES | |
| received_at | datetime | — | NO |