On Thu, 2010-11-18 at 14:44 +0530, Pramendra Choubey wrote: > Thanks for the useful suggestion. I have made changes in the database > structure. Also, please have a look on the comments below-
Thanks for the changes, and for the answers : ) > [Pramendra] I will use the facebook id for user as the foreign key in > other table. So, I am removing the id field from users table. Now > facebookid will be primary key with field name id. Alright - this might make it more complex to make the game standalone if we want later (ie, being able to play it outside of Facebook), but since we don't know yet if we'll actually want to do that, that's fine with me. > [Pramendra] yes, name is the file name of the card by which it will be > identified. Sounds good! > [Pramendra] I have decided to deal it with game_palyers table. Now, as > per your suggestion I am creating a separate table for storing the > information for invitations. Now, who will join the game (invited or > uninvited), will be stored in the game_players table. Perfect. > [Pramendra] It will be decided with flag generated in the fields > cardPicked and voteFor of game_players table. Yup, seems like a good solution. > - You're missing the actions table (cf the specifications - it logs > all the actions the players/authors perform in the game) > [Pramendra] we are working on it. Ok! Let me know if you need any details about this. > [Pramendra] We will explore for the recent terms and conditions of > facebook to store the information of users. List of friends is a > dynamic list which becomes change rapidly. So, we will deal it with > call of list of friends from facebook at time of execution. Actually, Facebook provides a solution for this: real time updates http://developers.facebook.com/docs/api/realtime Storing the friends is authorized by Facebook - it's even recommended as a best practice (cf http://developers.facebook.com/docs/best-practices ). And storing the friends in the local database (and all information retreived from Facebook about the player) is mentioned in the Card Stories specifications. > - 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. > [Pramendra] Ok, we are adding winners table for future extension. Perfect! Thanks a lot Pramendra. 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/
