Database Structure

Database structuring (subject to rapidly change)
Reference to Structuring Data, Best practices: https://firebase.google.com/docs/database/web/structure-data

• onlineChatSupport (to be decided)
• Forum (to be decided; probably usage: imageGameObjects + forumMessage + voteUP/voteDOWN)
• FAQs (FAQ Questions + Answers (text))
• users (list of users)
  • aviral (userID and userName; repeated names will be assigned names like Aviral_1, Aviral_2 and so on)
    • palace_1(palaceID)
      • unusedGameObjects (list of gameObjects added via android/chrome extension)
        • apple_1(gameObject name and id)
          • img_url: "http://placehold.it/350x150"
        • spiderman
          • img_url: "https://goo.gl/Dkp87Q"
      • placedGameObjects (list of gameObjects in user's saved game state)
        • uid (unique id of object)
          • position
            • x:1
            • y:3.5
            • z:401.7
          • rotation
            • x:0
            • y:0
            • z:8
          • typeId (type of object)
          • uid (appears again (redundant) since uid is public field and .jsonify() jsonifies all public fields - look into if can make this a protected field)
  • emre
    • palace_1
      • unusedGameObjects
        • banana_2
          • img_url: "http://placehold.it/400x150"
      • placedGameObjects
        • uid (unique id of object)
          • position
            • x:1
            • y:3.5
            • z:401.7
          • rotation
            • x:0
            • y:0
            • z:8
          • typeId
          • uid
  • adam
    • palace_1
      • unusedGameObjects (empty because no imageGameObjects added yet)
      • placedGameObjects (empty palace)
• publicGameObjects (list of gameObjects available to everyone)
  • apple (pre-existing)
  • banana (pre-existing)
  • banana_1 (pre-existing)
• publicImageGameObjects (list of imageGameObjects added by users but available to everyone; need to decide more sematics)
  • apple_1
    • img_url: "http://placehold.it/350x150"
    • added_by: aviral
  • spiderman
    • img_url: "https://goo.gl/Dkp87Q"
    • added_by: aviral
  • banana_2
    • img_url: "http://placehold.it/400x150"
    • added_by: emre