Hey all, as aforementioned, I'm new to SQL but can generally pick up things pretty quickly. I've outlined a few prototypes for a server, but I'm not sure what the most effective and efficient one is.
I have an online card game, and I would like to track the player's stats (wins/losses, rank, etc), the player's status (ingame, banned, off-line, etc) and I was stuck between a relationship based design with tables for each category
i.e: user (id, name, pw, email) and this links with the stats table to send back to client
or a plain table for all of the data.
Any advice or opinions?
โ08-11-2020 12:30 AM