| 字段 | 类型 | 键 | 可空 | 默认 | 注释 |
|---|---|---|---|---|---|
| id | char(36) | PRI | NO | ||
| settlement_id | char(36) | MUL | YES | ||
| order_id | char(36) | MUL | YES | ||
| order_no | varchar(64) | YES | |||
| merchant_id | char(36) | MUL | YES | ||
| store_id | char(36) | YES | |||
| order_amount | decimal(12,2) | YES | 0.00 | 订单金额 | |
| platform_fee | decimal(12,2) | YES | 0.00 | 平台佣金 | |
| payment_fee | decimal(12,2) | YES | 0.00 | 支付手续费 | |
| commission_amount | decimal(12,2) | YES | 0.00 | 分销佣金 | |
| refund_amount | decimal(12,2) | YES | 0.00 | ||
| merchant_income | decimal(12,2) | YES | 0.00 | 商户实得 | |
| settle_status | tinyint(4) | YES | 0 | 0待结算 1已结算 | |
| settled_at | datetime(3) | YES | |||
| is_deleted | tinyint(1) | YES | 0 | ||
| created_at | datetime(3) | YES | |||
| updated_at | datetime(3) | YES |
| 索引名 | 字段 | 类型 |
|---|---|---|
| idx_sd_merchant | merchant_id,settle_status | 普通 |
| idx_sd_order | order_id | 普通 |
| idx_sd_settlement | settlement_id | 普通 |
| PRIMARY | id | 唯一 |
| id | settlement_id | order_id | order_no | merchant_id | store_id | order_amount | platform_fee | payment_fee | commission_amount | refund_amount | merchant_income |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 08e5932f-8e68-40fb-8b17-6577b19f78e4 | ea97a944-011a-4a7f-b388-753f9f56518e | 7b69f110-1c90-5063-b46a-016bbdd6c908 | YJDEMO20261109004 | de000063-1000-4000-8000-000000000003 | 4ad3efb6-6913-4a67-af89-5304861bf08e | 33.42 | 1.00 | 0.20 | 1.67 | 0.00 | 30.55 |
| 0a76c89e-0f6d-4d34-86aa-6e475873d5df | 53cad352-017c-5b04-a560-c3ce1e3e1ed2 | 802c8048-65ea-587f-a0c9-5f358ecc5cf2 | YJDEMO20261109001 | de000063-1000-4000-8000-000000000003 | 4ad3efb6-6913-4a67-af89-5304861bf08e | 61.79 | 1.85 | 0.37 | 3.09 | 0.00 | 56.48 |
| 2cb5c9da-2ac4-4f59-a204-9dcc5b603886 | c113ed8a-7a91-5afe-88ba-c6014abac10d | 49e190f3-6f2c-57c7-9e61-96fb5fb6455a | YJDEMO20261109006 | de000063-1000-4000-8000-000000000003 | 4ad3efb6-6913-4a67-af89-5304861bf08e | 15.03 | 0.45 | 0.09 | 0.75 | 0.00 | 13.74 |