DB schema : array usage in a table
Posted by: Dhirajkumar Deore
Date: August 26, 2013 02:51AM

I am using Mysql(phpmyadmin).

My DB have 2 entities: users and players.
In which users are able to select 10 players of their choice from the pool of the players.
so i thought of using array attribute in user table like :

user(name,age,players[10],points);

and players table is :

players(name,details,point);

is it possible to use array attribute in table? if yes how? if no what should be my approach?

i am creating a system, where players will gain points individually and users are able to select upto 10 players only from pool of players.
and users gain points from those 10 players. Like fantasy football.
so pls help me with this schema.

Thanks

Options: ReplyQuote


Subject
Written By
Posted
DB schema : array usage in a table
August 26, 2013 02:51AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.