| 字段 | 类型 | 键 | 可空 | 默认 | 注释 |
|---|---|---|---|---|---|
| id | char(36) | PRI | NO | ||
| redemption_no | longtext | YES | |||
| member_user_id | char(36) | YES | |||
| target_type | longtext | YES | |||
| target_id | longtext | YES | |||
| target_snapshot | longtext | YES | |||
| amount | decimal(12,2) | YES | |||
| points | int(11) | YES | |||
| store_id | char(36) | YES | |||
| store_name | longtext | YES | |||
| merchant_id | char(36) | YES | |||
| operator_id | char(36) | YES | |||
| operator_name | longtext | YES | |||
| remark | longtext | YES | |||
| is_deleted | tinyint(1) | YES | |||
| created_at | datetime(3) | YES | |||
| updated_at | datetime(3) | YES | |||
| quantity | decimal(10,2) | YES |
| 索引名 | 字段 | 类型 |
|---|---|---|
| PRIMARY | id | 唯一 |
| id | redemption_no | member_user_id | target_type | target_id | target_snapshot | amount | points | store_id | store_name | merchant_id | operator_id |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 4288e631-9fb5-4b33-87ef-898d1de83606 | HX20261109055300 | 8ff30c1d-d0c1-409b-96ab-f5d0f4b16f98 | gift_entitlement | c148ca9c-738f-444c-bd22-975c99da7ad8 | G02 | 0.00 | 0 | 5627dcd6-1b08-4c20-bfb8-1d3f44dfd3f8 | 云届锦江旗舰店 | NULL | NULL |
| 55dc4e8b-83f9-43e1-888c-d60c18b93050 | HX20261109003 | 8ff30c1d-d0c1-409b-96ab-f5d0f4b16f98 | coupon | cp_001 | 满99减15券 | 0.00 | 0 | 5627dcd6-1b08-4c20-bfb8-1d3f44dfd3f8 | 云届锦江旗舰店 | de000063-1000-4000-8000-000000000003 | NULL |
| 759174b1-a741-489d-a428-6358605406d0 | HX20261109001 | 8ff30c1d-d0c1-409b-96ab-f5d0f4b16f98 | points_order | 5d642857-01ec-4216-b3cd-4df75ab6eff3 | 遵义特色辣椒酱 | 29.90 | 0 | 5627dcd6-1b08-4c20-bfb8-1d3f44dfd3f8 | 云届锦江旗舰店 | de000063-1000-4000-8000-000000000003 | NULL |