UML Time!
This week i got a start on working out how the database would look. I decided to start simple with a basic UML layout.
I wanted to keep it basic to start with and then expand as the weeks go by and we need more details. I’ll be using Mongo as my database solution. As it uses simple JSON storage which makes it easy to remodel the db anytime we need. And it has great query methods allowing you chain filters and sort by anything and everything very easily.
The basic concept is the database will hold a list of Users, Votes and Events.
Events hold:
A list of users registered
A start date
Users hold:
Their ID (unique)
Their username
An array of events they are registered for
An array of votes (Votes are what they ranked another player on)
A stats Object (which holds their user preferences for Fun, Skill, Communication, Teamwork and friendliness)
Their email
Their discord ID (taken when they auth using discord)
Votes hold:
The ID of the person who voted
The ID of the person being voted on
An object of scores for each value we are ranking them on. (fun, skill, communication, teamwork and friendliness.)
After each game the users will be able to rank the players they played with and give them a score out of 5 for each field. This will assist in deciding whether to match that player together again.
Stay tuned for more information