Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

New Database format #1

Open
arichbart opened this issue Mar 28, 2019 · 0 comments
Open

New Database format #1

arichbart opened this issue Mar 28, 2019 · 0 comments

Comments

@arichbart
Copy link
Owner

Below is my early brainstorm of how to update database. The main differences are the region table would be new and we would move all scoring into the scoreboard table. Currently there is some part of the scoring in the teams, grandpas, specials and overalls table.

  1. Region
    Not sure how we want to store these...there are always 4 regions with potentially different names every year. At first I was thinking something like this:
    4 total records
    Record 1 - id => 1 , region_name => east
    Record 2 - id => 2 , region_name => west etc.

  2. Teams
    Team Name, Seed, RegionId, wins, eliminated

  3. Scoreboard
    userId, grandpa total score, special total score, overall score

  4. Grandpa Selections
    userId, top left team id, top right team id, etc.

  5. Seeded Selections
    userId, top left team id, top right team id, etc.

@arichbart arichbart assigned arichbart and unassigned arichbart Mar 28, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant