I have a data set of users and a data set of challenges. About the relations: A user has “Available Challenges”, “Ongoing Challenges” and “Completed Challenges”. A challenge has “Available Users”, “Ongoing Users” and “Completed Users”. So n:n relation.
When a user accepts an available challenge, I want to ask him for how many days he intends to do it in a row. Then after x days I want to reward him with TotalRewardAmount = (x days * DailyRewardAmount). Is there a way to do this? I haven’t found a way to save the days value and then update the user’s reward/EXP (let’s say) after those days. Thanks for any help.