F1 Fantasy League

Introduction

This is an F1 Fantasy League app. It is solely being built as part of a training project.

Purpose

The purpose of the F1 Fantasy League app (codename: Drift Kings) is to provide a space for friends to get together and guess how the drivers will do on any given week during the F1 season.

---

Features

Must Have

• A person must be able to #.
• A person must be able to make picks.
• An admin must be able to add and remove race/sprint/driver/team/race result info in the database.
• A person must be able to see how they did in each Grand Prix weekend.
• A person should be able to see a leaderboard that shows the current updated standings of everyone participating.

Should Have

• A person should not be able to enter picks once qualifying starts.
• A person should have a way to know when the picks they have made will lock.
• A person should be able to see their own profile and the profiles of others.

Could Have

• The app could have a pseudo-calendar showing when and where each Grand Prix (and it's associated events) will take place. This could be as simple as a list.
• The app could have an admin section where the admin could perform the tasks necessary to maintain the app. Add/delete players, add/delete race/sprint/driver/team/race result info, etc.
• The app could include driver/team logos/avatars.

Won't Have / Wish List

• Driver/team/grand prix profile pages each with info about the driver, team, or grand prix.
• Fantasy league history page with results for each year. Who participated, final league standings, etc.

---

Entity Relationship Diagrams

%%{init: {
  "theme": "default",
  "themeCSS": [
    ".er.entityBox { fill: #e10600; stroke: #cb0500; stroke-width: 2px}",
    ".er.attributeBoxEven { stroke: #cb0500 }",
    ".er.attributeBoxOdd { stroke: #cb0500 }"
  ]
}}%%

erDiagram
  PLAYER ||--o{ PICKS : makes
  TEAM ||--|{ DRIVER : has
  PICKS ||--|| GRAND-PRIX : includes
  PICKS ||--|| CHOICES : includes
  PICKS ||--|| TEAM : includes
  PICKS ||--|| DRIVER : includes

Loading

%%{init: {
  "theme": "default",
  "themeCSS": [
    ".er.entityBox { fill: #e10600; stroke: #cb0500; stroke-width: 2px}",
    ".er.attributeBoxEven { stroke: #cb0500 }",
    ".er.attributeBoxOdd { stroke: #cb0500 }"
  ]
}}%%

erDiagram
  PLAYER {
    int id
    string first_name
    string last_name
  }
  DRIVER {
    int id
    string first_name
    string last_name
    int team_id
    int driver_number
    string place_of_birth
    string country
  }
  TEAM {
    int id
    string name
  }
  GRAND-PRIX {
    int id
    string grand_prix_name
    string grand_prix_location
    DateTime fp1_start
    DateTime fp2_start
    DateTime fp3_start
    DateTime qualifying_start
    DateTime race_start
    DateTime sprint_qualifying_start
    DateTime sprint_race_start
    boolean is_sprint_weekend
  }
  CHOICES {
    int id
    string choice "This is 1st, 2nd, 3rd, 10th, DNF, Top Team, Sprint 10th, Sprint DNF, Sprint Top Team"
  }
  PICKS {
    int id
    int player_id
    int grand_prix_id
    int choice_id
    int pick_id "This will be either a driver id or a team id depending on the choice"
  }
  PLAYER ||--o{ PICKS : makes
  TEAM ||--|{ DRIVER : has
  PICKS ||--|| GRAND-PRIX : includes
  PICKS ||--|| CHOICES : includes
  PICKS ||--|| TEAM : includes
  PICKS ||--|| DRIVER : includes

Loading

---

The F1 Fantasy League app is an independent project and is not affiliated with, endorsed by, or in any way connected to Formula 1, the FIA, or any of their affiliates. The contents and functionalities of this app are solely the responsibility of its creators, and any opinions expressed do not reflect those of Formula 1 or the FIA.