search

mwin1201 / fpl-draft-2022

FPL Draft website to track league team performance stats
2 stars 1 forks source link

Table development for playoffs #136

Open mwin1201 opened 11 months ago

mwin1201 commented 11 months ago

League Data Table

The purpose of this table is to track owners and their playoff status, their old league, the year, etc.

Will need to determine when to write this data to the database. Week 36? When promotional playoffs start?

Table columns:

  1. id
  2. owner id (foreign key)
  3. season_year
  4. league_started
  5. league_ended
  6. championship_playoff
  7. champions_league
  8. table_position
  9. relegation
  10. promotion
  11. total_points
  12. total_goals
  13. total_assists
mwin1201 commented 11 months ago

table columns: id -- 1 season_year -- "23-24" league_started_in -- "premiership" league_ended_in -- "premiership" championship_playoff -- "NA" champions_league -- "N" table_position -- 5 relegation -- "N" promotion -- "NA" total_points -- 1200 total_goals -- 40 total_assists -- 35 season_complete -- "True" owner_id -- 82627

mwin1201 commented 9 months ago

INSERT INTO league_data (id, season_year, league_started_in, league_ended_in, championship_playoff, champions_league, table_position, relegation, promotion, season_complete, owner_id, created_at, updated_at) VALUES (1, '23-24', 'premiership', 'premiership', 'NA', 'N', 0, 'N', 'NA', false, 127064, NOW(), NOW()), (2, '23-24', 'premiership', 'premiership', 'NA', 'N', 0, 'N', 'NA', false, 82627, NOW(), NOW()), (3, '23-24', 'premiership', 'premiership', 'NA', 'N', 0, 'N', 'NA', false, 83210, NOW(), NOW()), (4, '23-24', 'premiership', 'premiership', 'NA', 'N', 0, 'N', 'NA', false, 87087, NOW(), NOW()), (5, '23-24', 'premiership', 'premiership', 'NA', 'N', 0, 'N', 'NA', false, 87094, NOW(), NOW()), (6, '23-24', 'premiership', 'premiership', 'NA', 'N', 0, 'N', 'NA', false, 87118, NOW(), NOW()), (7, '23-24', 'premiership', 'premiership', 'NA', 'N', 0, 'N', 'NA', false, 87711, NOW(), NOW()), (8, '23-24', 'premiership', 'premiership', 'NA', 'N', 0, 'N', 'NA', false, 119323, NOW(), NOW()), (9, '23-24', 'premiership', 'premiership', 'NA', 'N', 0, 'N', 'NA', false, 131621, NOW(), NOW()), (10, '23-24', 'premiership', 'premiership', 'NA', 'N', 0, 'N', 'NA', false, 211849, NOW(), NOW()), (11, '23-24', 'championship', 'championship', 'N', 'NA', 0, 'NA', 'N', false, 70583, NOW(), NOW()), (12, '23-24', 'championship', 'championship', 'N', 'NA', 0, 'NA', 'N', false, 70949, NOW(), NOW()), (13, '23-24', 'championship', 'championship', 'N', 'NA', 0, 'NA', 'N', false, 71079, NOW(), NOW()), (14, '23-24', 'championship', 'championship', 'N', 'NA', 0, 'NA', 'N', false, 72889, NOW(), NOW()), (15, '23-24', 'championship', 'championship', 'N', 'NA', 0, 'NA', 'N', false, 72926, NOW(), NOW()), (16, '23-24', 'championship', 'championship', 'N', 'NA', 0, 'NA', 'N', false, 75968, NOW(), NOW()), (17, '23-24', 'championship', 'championship', 'N', 'NA', 0, 'NA', 'N', false, 130041, NOW(), NOW()), (18, '23-24', 'championship', 'championship', 'N', 'NA', 0, 'NA', 'N', false, 130057, NOW(), NOW()), (19, '23-24', 'championship', 'championship', 'N', 'NA', 0, 'NA', 'N', false, 179676, NOW(), NOW()), (20, '23-24', 'championship', 'championship', 'N', 'NA', 0, 'NA', 'N', false, 185504, NOW(), NOW());