任務牆 table schema.md
13 additions, 13 deletions
| ... | ... | @@ -1,4 +1,4 @@ |
| 1 | - # 1. 任務設定主表 (TaskMasterSetting) | |
| 1 | + # 1. 任務設定主表 (MissionMasterSetting) | |
| 2 | - # 2. 任務設定子表 (TaskSubSetting) | |
| 2 | + # 2. 任務設定子表 (MissionSubSetting) | |
| 3 | - | master_id | Integer | 對應的主任務 ID ([taskMasterSetting.ID](http://taskMasterSetting.ID)) | | | |
| 3 | + | master_id | Integer | 對應的主任務 ID ([MissionMasterSetting.ID](http://MissionMasterSetting.ID)) | | | |
| 4 | - # 3. 任務名單設定 (TaskMemberList) | |
| 4 | + # 3. 任務名單設定 (MissionMemberList) | |
| ... | ... | @@ -57,14 +57,14 @@ |
| 57 | - # 5. 用戶任務紀錄表 (UserTaskLog) | |
| 57 | + # 5. 用戶任務紀錄表 (UserMissionLog) | |
| 58 | -| sub_id (rule engine寫入) | Integer | [FK] [TaskSubSetting.id](http://TaskSubSetting.id) | 5001 | | |
| 59 | - | master_id (rule engine寫入) | Integer | [FK] [TaskMasterSetting.id](http://TaskSubSetting.id) | | | |
| 58 | + | sub_id (rule engine寫入) | Integer | [FK] [MissionSubSetting.id](http://MissionSubSetting.id) | 5001 | | |
| 59 | +| master_id (rule engine寫入) | Integer | [FK] Mission[MasterSetting.id](http://TaskSubSetting.id) | | | |
| 60 | -| master_id | Integer | [FK] [TaskMasterSetting.id](http://tasksubsetting.id/) | | | |
| 61 | - | sub_id | Integer | [FK] [TaskSubSetting.id](http://tasksubsetting.id/) | 累計型使用 | | |
| 60 | + | master_id | Integer | [FK] Mission[MasterSetting.id](http://tasksubsetting.id/) | | | |
| 61 | +| sub_id | Integer | [FK] Mission[SubSetting.id](http://tasksubsetting.id/) | 多門檻型使用 | | |
| 62 | - | record_id | Integer | [UserTaskRecord.id](http://UserTaskRecord.id) (寫入的Record.i) | | | |
| 62 | + | record_id | Integer | [UserMissionRecord.id](http://UserMissionRecord.id) (寫入的Record.i) | | | |
| 63 | - # 8. 獎勵任務表 (AwardTaskSettings) | |
| 63 | + # 8. 獎勵任務表 (AwardMissionSettings) | |
| 64 | -| sub_id | Integer (nullable) | [FK] [TaskSubSetting.id](http://tasksubsetting.id/) | 指定型任務此欄位不會有值 | | |
| 65 | - | master_id | Integer | [FK] [TaskMasterSetting.id](http://tasksubsetting.id/) | | | |
| 64 | + | sub_id | Integer (nullable) | [FK] Mission[SubSetting.id](http://tasksubsetting.id/) | 指定型任務此欄位不會有值 | | |
| 65 | +| master_id | Integer | [FK] Mission[MasterSetting.id](http://tasksubsetting.id/) | | |