payment_orders支付
yjgw 库的实体表 · 22 个字段 · 主键 id · 数据行约 9
字段结构
| 字段 | 类型 | 键 | 可空 | 默认 | 注释 |
|---|
| id | char(36) | PRI | NO | | |
| order_no | longtext | | YES | | |
| phone | longtext | | YES | | |
| status | longtext | | YES | | |
| platform | longtext | | YES | | |
| total_amount | decimal(12,2) | | YES | | |
| description | longtext | | YES | | |
| qr_code_url | longtext | | YES | | |
| payment_url | longtext | | YES | | |
| platform_trade_no | longtext | | YES | | |
| platform_refund_no | longtext | | YES | | |
| platform_transaction_id | longtext | | YES | | |
| platform_data | longtext | | YES | | |
| user_id | longtext | | YES | | |
| platform_buyer_id | longtext | | YES | | |
| system_user_id | char(36) | | YES | | |
| user_metadata | longtext | | YES | | |
| paid_at | datetime(3) | | YES | | |
| expired_at | datetime(3) | | YES | | |
| created_at | datetime(3) | | YES | | |
| updated_at | datetime(3) | | YES | | |
| is_deleted | tinyint(1) | | YES | | |
索引
样本数据 · 已脱敏 · 前 3 行
| id | order_no | phone | status | platform | total_amount | description | qr_code_url | payment_url | platform_trade_no | platform_refund_no | platform_transaction_id |
|---|
| 0366d720-1657-5c5d-8d17-fe717b136f2c | YJDEMO20261109005 | 138****0002 | SUCCESS | wechat | 19.14 | 订单支付:YJDEMO20261109005 | NULL | NULL | NULL | NULL | NULL |
| 2359ec2c-9b7d-54bb-bac5-8731cb506aaf | YJDEMO20261109003 | 193****9547 | SUCCESS | balance | 51.52 | 订单支付:YJDEMO20261109003 | NULL | NULL | NULL | NULL | NULL |
| 291e27ba-3be7-5ed7-b3f8-4db3a00d385b | YJDEMO20261109006 | 193****9547 | SUCCESS | alipay | 15.03 | 订单支付:YJDEMO20261109006 | NULL | NULL | NULL | NULL | NULL |