Search the Community
Showing results for tags 'relationship'.
Found 2 results
-
Any database structuring gurus who can help me a little with this, I really just feels there is something wrong with this xD But don't know how I should do it differently :/ If the description on the image isn't enough, just ask and I'll try to explain it in more detail -
I am working on phpmyadmin. i want to create a system in which users will select 10 players from pool of players and gain points from those 10 players, just like fantasy football. So my first solution was tables: users(name,details,team[10],points gained) and players(name,details,points gained by individual player); but i am not sure how to get that team array in users table. so i searched for solutions, then somesone suggested about creating one more table team and some thing about foreign keys. But still i am confused how to do this? and 1 more question should i use phpmyadmin or mysql workbench to do this . right now i have both installed on system but i have never used mysql workbench. pls help. Thanks
