• Wednesday

    • Private work.
    • BoA got more than 15B in deposits over the last couple days as people move to bigger (safer?) banks.
    • NSU advanced to the DII elite 8 last night and got reseeded 1st: https://www.ncaa.com/brackets/basketball-men/d2/2023
    • FB cutting another 13%. Anchorage 20% (they’re only a few hundred strong).
    • Finished Community.
    • SBSC.
    • Be careful with the team/prediction/location schema change; although historically team1=favorite and team2=underdog in the database, that’s not the case. Either team can have any of the 3 predictions (favorite/pickem/underdog). I’ve written all logic in the app to respect that (look it up where necessary).
    • Added observers for basically every stat calculation (eg overperformance margin). The only exception is pick%. It’s an SBSC stat. I intentionally just calculate it in the stats module – don’t want this being a Team.pick_counts col observing the Pick table (for example), then it would update on every pick (frequent). Just calc when the stats view is requested/read by a user (infrequent).
    • Basically rewrote the whole app on this ticket. Data, backend, and frontend.
    • Renamed line/lines to game/games to be more clear about what the table is.
    • Instead of associating team/prediction/location on each game row, duplicated, I split it out so each game just has two objects, opponent1 and opponent2. They FK to the Opponents table, which has cols for team/prediction/location (nested FKs to their respective tables).