Implement Curation Data Models

[nicholasri]

Data Modeling

Reference: Develop the database using this issue as a guideline: https://github.com/SanFelipeStudios/RomeTwo/issues/11

As an iOS Engineer, I want to define and implement the Data Models we are going to use for our application in MongoDB Atlas and as structs in SwiftUI. Below are the defined data models necessary for the Curation View.

Consider the relationships available in Realm: https://www.mongodb.com/docs/realm/sdk/swift/model-data/#model-data---swift-sdk

TODO: Create a follow up story to research which cloud service provider to use for storage of Media.

Defined Models

One-To-Many: Users can have many Curations

• Curation
  • id: UUID
  • userId: UUID (inverse relationship)
  • gameId: UUID (To-one)
  • heading: String
  • title: String
  • subheading: String
  • summary: String

Users should be in their own database.

One-To-Many: Users can have many games

• User
  • id: UUID
  • username: String
  • firstName: String
  • lastName: String
  • addresses: [Address]
  • email: String
  • phone: String
  • cart / Wishlist: Cart (Changes Often)
  • wishlist: Wishlist (Changes Often)
  • payment: [Payment]
  • Library: [UUID]
  • Curation: [UUID] (linking)

One-To-Many: Users can have many Address

• Address
  • isMailingAddress: bool
  • isBillingAddress: bool
  • addressLine1: String
  • addressLine2: String
  • zipcode: Integer
  • state: String
  • city: String
  • country: Country

One-To-One: Address can only have one country

• Country:
  • id: UUID
  • name: String

One-To-Many: Publishers and Developers can have many games

• Game

  • id: UUID
  • Title: String
  • Description: [String]
  • DeveloperId: UUID (inverse)
  • PublisherId: UUID (inverse)
  • Price: Double
  • hasInAppPurchases: Boolean
  • Release Date: String
  • labels: [UUID] (Many-To-Many)
  • Reviews: [UUID] (linking) Unbounded Number of Documents
  • Media: [Integer: UUID] (linking)

• Developer

  • id: UUID
  • Name: String
  • Games: [UUID] (linking)

• Publisher

  • id: UUID
  • Name: String
  • Games: [UUID] (linking)

Many-To-Many: Games can have many labels and labels can have many games

• Label (Genre, Multiplayer, etc)
  • id: UUID
  • games: [UUID] (This is unbounded)
  • gamesTbc: [GameTbc] (TODO Later)
  • Name: String
  • Description: String

One-To-Many: Games can have many reviews

• Review
  • id: UUID
  • Game: UUID
  • UserId: UUID
  • Recommend: Bool
  • Body: String

One-To-Many: Games can have many media files

• Media
  • id: UUID
  • Game: UUID (inverse)
  • Name: String
  • Type: String
  • Url: String

Acceptance Criteria

Given	When	Then
A Curation View	The Page is loading	Request the data from mongo
""	The data from mongo has been retrieved	Fill out the data and images in the Curation View
""	The data from mongo could NOT be retrieved	Display the Internet Connectivity Error View

[nicholasri]

Updated data models in the code and in the schema for the database

[nicholasri]

@Dusharm Can you please review the PR tied to this story?