Trying to figure drizzle & Supabase out

Hi everyone, I’m new to working with DBs and ORMs, so please bear with me on this. I’m building a part of my website that allows voters to submit a ballot of their top 25 college football teams every week. Everything will be added up and a final top 25 will be comprised of all the votes for that week. I’m basically looking to create https://www.espn.com/college-football/rankings/_/poll/20/week/1/year/2023/seasontype/3 I’m using Drizzle, Supabase, Clerk, Next.js, and Sanity (where articles and the actual teams that can be voted on live). I honestly don’t even know where to start so I’ve Googled around, asked ChatGPT, tried to find other examples but 🤷🏻‍♂️. Everywhere I’ve looked they suggest a single “votes” table where each team in a ballot is an individual row in the database. This would equate to 425 rows for a single voter +/- 25 for the “preseason” and “final” Top 25. For some reason, that doesn’t seem scalable into the future as I add more voter (currently at 6 looking to grow to 20+). I also thought, do I need another table for the weekly final Top 25 with the amount of points each team received (25 points for a 1st place vote down to 1 point for a 25th place vote). Any guidance/code would be grateful as I think I’m at the analysis paralysis point where I’m afraid I’m going to “mess something up”. I was thinking of something like this, but not entirely sure if this is the best possible way

ESPN

2023 FCS Coaches Poll College Football Rankings, Final Rankings - ESPN

Find the complete NCAAF Final Rankings rankings on ESPN. Includes the full votes and trend for the top 25 NCAAF teams.