任務牆 table schema.md
28 additions, 0 deletions
| ... | ... | @@ -73,6 +73,7 @@ |
| 73 | +| batch_id | NUMBER | cms batch id | | | |
| 74 | + | |
| 75 | +# 11. 人工改檔紀錄表 (MANUAL_REMEDIAL_LOG) | |
| 76 | + | |
| 77 | +| 名稱欄位 | 型態 | 欄位說明 | example | | |
| 78 | +| ---| ---| ---| --- | | |
| 79 | +| id | NUMBER | PK | 90001 | | |
| 80 | +| user_id | VARCHAR2(15 CHAR) NOT NULL | 用戶ID | USER_667788 | | |
| 81 | +| sub_id | NUMBER NOT NULL | [FK] [MissionSubSetting.id](http://MissionSubSetting.id) | 5001 | | |
| 82 | +| master_id | NUMBER NOT NULL | [FK] Mission[MasterSetting.id](http://TaskSubSetting.id) | | | |
| 83 | +| count | NUMBER DEFAULT 0 | 次數 | 1 | | |
| 84 | +| create_time | Timestamp | 建立時間 | 2025-12-29 09:00:00 | | |
| 85 | +| batch_id | NUMBER | cms batch id | | | |
| 86 | +| chunk_id | NUMBER | batch service chunk id | | | |
| 87 | + | |
| 88 | +# 12. 人工改檔結果log表 (MANUAL_REMEDIAL_EXECUTION) | |
| 89 | + | |
| 90 | +| 名稱欄位 | 型態 | 欄位說明 | example | | |
| 91 | +| ---| ---| ---| --- | | |
| 92 | +| id | NUMBER | PK | 90001 | | |
| 93 | +| user_id | VARCHAR2(15 CHAR) NOT NULL | 用戶ID | USER_667788 | | |
| 94 | +| sub_id | NUMBER NOT NULL | [FK] [MissionSubSetting.id](http://MissionSubSetting.id) | 5001 | | |
| 95 | +| master_id | NUMBER NOT NULL | [FK] Mission[MasterSetting.id](http://TaskSubSetting.id) | | | |
| 96 | +| count | NUMBER DEFAULT 0 | 次數 | 1 | | |
| 97 | +| create_time | Timestamp | 建立時間 | 2025-12-29 09:00:00 | | |
| 98 | +| batch_id | NUMBER | cms batch id | | | |
| 99 | +| chunk_id | NUMBER | batch service chunk id | | | |
| 100 | +| result | VARCHAR2 | 執行狀態 | SUCCESS : 成功; FAILED : 失敗 | |