任務牆 table schema.md
13 additions, 14 deletions
| ... | ... | @@ -36,14 +36,13 @@ |
| 36 | -| sort_order | NUMBER(5) | 顯示排序 | 1 | | |
| 37 | - | master_id | NUMBER not null , , `有設定FK` `- MISSION_MASTER_SETTING` | 對應的主任務 ID ([MissionMasterSetting.ID](http://MissionMasterSetting.ID)) | 1 | | |
| 36 | + | master_id | NUMBER not null , `有設定FK` `- MISSION_MASTER_SETTING` | 對應的主任務 ID ([MissionMasterSetting.ID](http://MissionMasterSetting.ID)) | 1 | | |
| 38 | - # 5. 用戶任務紀錄表 (UserMissionLog) | |
| 37 | + # 5. 用戶任務紀錄表 (USER_MISSION_LOG) - paging | |
| 39 | -| sub_id (rule engine寫入) | Integer | [FK] [MissionSubSetting.id](http://MissionSubSetting.id) | 5001 | | |
| 40 | - | master_id (rule engine寫入) | Integer | [FK] Mission[MasterSetting.id](http://TaskSubSetting.id) | | | |
| 38 | + | sub_id (rule engine寫入) | NUMBER NOT NULL | [FK] [MissionSubSetting.id](http://MissionSubSetting.id) | 5001 | | |
| 39 | +| master_id (rule engine寫入) | NUMBER NOT NULL | [FK] Mission[MasterSetting.id](http://TaskSubSetting.id) | | | |
| 41 | - # 6. 用戶任務紀錄總計表 (UserSummaryRecord) | |
| 40 | + # 6. 用戶任務紀錄總計表 (USER_SUMMARY_RECORD) -paging | |
| 42 | - | create_time | Timestamp | 建立時間 | 2025-12-22 11:00:00 | | |
| 41 | + | create_time | TIMESTAMP(6) NOT NULL | 建立時間 | 2025-12-22 11:00:00 | | |
| 43 | - | invalid | boolean | 是否為不法 | | | |
| 42 | + | invalid | NUMBER(1) | 是否為不法 | | | |
| 44 | - # 7. 用戶事件錯誤紀錄表 (UserEventError) | |
| 43 | + # 7. 用戶事件錯誤紀錄表 (USER_EVENT_ERROR) - paging | |
| 45 | - | user_id | VARCHAR2(15 CHAR) NOT NULL | 用戶唯一識別碼 | USER_667788 | | |
| 44 | + | user_id | VARCHAR2(15 CHAR) NOT NULL | 用戶id | USER_667788 | | |
| 46 | - | create_time | Timestamp | 建立時間 | 2025-12-29 09:10:00 | | |
| 45 | + | create_time | TIMESTAMP(6) NOT NULL | 建立時間 | 2025-12-29 09:10:00 | | |
| 47 | - | source | VARCHAR2(10 CHAR) | producer error<br>consumer error (not in eventlog)<br>conusmer error (in eventlog)<br>rule engine error | PRODUCER, 2. CONSUMER_NOT_EXIST3. CONSUMER_EXIST4. RULE_ENGINE | | |
| 46 | + | source | VARCHAR2(10 CHAR) | producer error<br>consumer error (not in eventlog)<br>conusmer error (in eventlog)<br>rule engine error | 1. PRODUCER<br>2. CONSUMER_NOT_EXIST<br>3. CONSUMER_EXIST<br>4. RULE_ENGINE | | |
| 48 | -| master_id | NUMBER | [FK] Mission[MasterSetting.id](http://tasksubsetting.id/) | | | |
| 49 | - | award_type | VARCHAR2(10 CHAR) | 獎勵類型 | point/voucher | | |
| 47 | + | master_id | NUMBER NOT NULL, `有設定FK- MISSION_MASTER_SETTING` | [FK] Mission[MasterSetting.id](http://tasksubsetting.id/) | | | |
| 48 | +| award_type | VARCHAR2(10 CHAR) | 獎勵類型 | 點數: POINT / 票券: VOUCHER | |