Database schema - Githubissues

acwiesn / weekly-pickem

0 stars 0 forks source link

Database schema #5

Open acwiesn opened 7 years ago

acwiesn commented 7 years ago

[ ] Create database schema (possibly using mongoose)
[ ] Test to ensure it is optimal for app
[ ] Connect with app using node so front end can then display data

acwiesn commented 7 years ago

Entry Model

{
    "Entries": {
        "Week": "string",
        "User": "string",
        "picks": {
            "game1": "string",
            "team": "string",
            "lock": "flag",
            "points": "number"
        },
        "game1": "string",
        "team": "string",
        "lock": "flag",
        "points": "number"
    }
}

acwiesn commented 7 years ago

Games Model

{
  "Games": {
    "Week1": {
      "Game1": {
        "gameTime": "date",
        "Team1": {
          "Name": "string",
          "Points": "number",
          "Spread": "number"
        },
        "Team2": {
          "Name": "string",
          "Points": "number",
          "Spread": "number"
        }
      },
      "Game2": {
        "gameTime": "date",
        "Team1": {
          "Name": "string",
          "Points": "number",
          "Spread": "number"
        },
        "Team2": {
          "Name": "string",
          "Points": "number",
          "Spread": "number"
        }
      }
    }
  }
}