Is this correct database schema?
I am using phpmyadmin.
I want to create a website (like fantasy football) in which users will create account and select the players from the pool to create their team of 10 players.
Based on performance each player will earn points. and then user will also earn points from 10 players(his team).
so i searched on internet and came out with db schema.
1)User (u_id, details)
3)user_team(t_id, u_id(FK), p_id(FK), team_name, points)
so now problem is, there must be only 10 rows in the user_team table for a particular user, correct?
I am confused about it? Is this the correct schema? or am i missing something..something more accurate?