On Wed, 2010-11-17 at 21:43 +0530, Pramendra Choubey wrote: > I have attached DB structure with this email, please take a look and > let me know if there are any comments.
Thanks for this document! It will definitely be helpful to discuss this now imho - here are a few comments: - game_players.userId => you say in the legend that it's the Facebook id of the player of the game - I guess you meant the foreign key from the users table? - Cards don't have names : ) (except if you mean the filename!) - Players can freely join a game, even if they haven't been invited - they can even take the seats of players who had been invited if they are faster and there isn't enough room in the game. So I would have probably created a separate "invitations" table to not mix both concepts, since someone who is invited only actually becomes a player when he picks a card. - Email reminder are sent when a player or an author hasn't played (chosen a card, voted, published a game...) - how do you plan to track time? - You're missing the actions table (cf the specifications - it logs all the actions the players/authors perform in the game) - In the user table, the fields to store the personal information of the players are missing (age, email, etc.). Also, you may need a table to store the list of friends, the likes, etc. - For performance, you may want to store the number of games played/won/lost for each player - otherwise it could be quite costly to calculate the leaderboard, especially with players with hundred of friends. > While working on the code a couple questions cropped up - > · What will be the character limit of sentence for card. We can probably start with a limit of 100 characters (about 1.5 line in a word processor). > * When the game is newly launched, in leaderboard there will > not any friends. In that case, if we display blank it will not > look good. True - good catch. Maybe we could replace the picture/name of the player with a question mark - Deborah, what do you think? What would look good? > May you please provide the percentage of width of HTML pages to fill > the blank white space. I'll let you both sort out that part together - let me know if any help is needed! Xavier. _______________________________________________ Farsides mailing list - [email protected] Wiki: http://farsides.com/ List: http://farsides.com/ml/ Forum: http://farsides.com/forum/ Ideas: http://farsides.com/ideas/ Chat: http://farsides.com/chat/
