任務牆 table schema.md
18 additions, 10 deletions
| ... | ... | @@ -44,22 +44,30 @@ |
| 44 | - # 4. 用戶任務紀錄子表 (UserTaskRecord) | |
| 44 | + # 4. 用戶任務事件紀錄表 (UserTaskRecord) | |
| 45 | +| content | String | 詳細紀錄內容(raw data) | {<br> {<br> "ticket_id": "01", "name": "C券","point":"500","deduct_time":"2026/01/01 00:09:00","amount":1<br> },<br> {<br> "ticket_id": "01", "name": "C券","point":"500","deduct_time":"2026/01/01 09:09:00","amount":1<br> }<br>} | | |
| 46 | +| source | String | CMS/system/erroHandle | 計分來源 | | |
| 47 | +| create_time | Timestamp | 建立時間 | 2025-12-29 09:00:00 | | |
| 48 | + | |
| 49 | +# 5. 用戶任務邏輯判定表 (UserTaskLogicEvaluation) | |
| 50 | + | |
| 51 | +| 名稱欄位 | 型態 | 欄位說明 | example | | |
| 52 | +| ---| ---| ---| --- | | |
| 53 | +| id | Integer | PK | 90001 | | |
| 54 | +| user_id | String | 用戶唯一識別碼 | USER_667788 | | |
| 45 | - | content | String | 詳細紀錄內容(raw data) | {<br> {<br> "ticket_id": "01", "name": "C券","point":"500","deduct_time":"2026/01/01 00:09:00","amount":1<br> },<br> {<br> "ticket_id": "01", "name": "C券","point":"500","deduct_time":"2026/01/01 09:09:00","amount":1<br> }<br>} | | |
| 55 | + | record_id | String | [FK] User[Task](http://TaskSubSetting.id)[Record.id](http://Record.id) | 1 | | |
| 46 | -| source (rule engine寫入) | String | CMS/system | 計分來源 | | |
| 47 | -| create_time | Timestamp | 建立時間 | 2025-12-29 09:00:00 | | |
| 48 | - # 5. 用戶任務紀錄總計表 (UserSummaryRecord) | |
| 56 | + # 6. 用戶任務紀錄總計表 (UserSummaryRecord) | |
| 57 | +| invalid | boolean | 是否為不法 | | | |
| 49 | - # 6. 用戶任務錯誤紀錄表 (UserTaskError) | |
| 58 | + # 7. 用戶任務錯誤紀錄表 (UserTaskError) | |
| 50 | - # | |
| 59 | + # 8. 獎勵任務表 (AwardTaskSettings) | |
| 51 | -# 7. 獎勵任務表 (AwardTaskSettings) | |
| 52 | - | |
| 53 | - # 8. 用戶領獎紀錄表 (UserAwardRecord) | |
| 60 | + # 9. 用戶領獎紀錄表 (UserAwardRecord) | |
| 61 | +| invalid | boolean | 是否為不法 | | |