Rewards for every house member dependent on house points.
New Tab: large table where you can add new rewards as well as their requirements depending on when someone joined (hard-coded for now to 2 entry years)
New Tab: rewards for people viewing what they've got and what they're owed.
New Table for rewards: String for the type of reward, int for the number of points required, serial for ID
New Table for reward receiving: just a reference to the ID of the person and the reward. If the person has an entry in that table, then they've been awarded - awards to be given should be manually worked out in the backend using the rewards table.
Rewards for every house member dependent on house points.
New Tab: large table where you can add new rewards as well as their requirements depending on when someone joined (hard-coded for now to 2 entry years) New Tab: rewards for people viewing what they've got and what they're owed.
New Table for rewards: String for the type of reward, int for the number of points required, serial for ID New Table for reward receiving: just a reference to the ID of the person and the reward. If the person has an entry in that table, then they've been awarded - awards to be given should be manually worked out in the backend using the rewards table.