Table design help

--0016364edc1e04c57b048fda3d9c
Content-Type: text/plain; charset=ISO-8859-1

Hi all,

Needing some advice on my tables design.

Basically I am designing a soccer application, and have a table which
contains player_bids (the values of which a player costs to be transferred
between clubs). Can someone please offer some input on the best way in
which I should design the financial table for each team to hold the teams
current balance,historic financial information in terms of player wages and
how best I should link it to the players_bids table, if I should at all ?
Other information storage in the financial table would be things like prize
money, gate receipts etc

Thanks for any help.

Cheers
Neil

--0016364edc1e04c57b048fda3d9c--

Re: Table design help

At 04:23 PM 9/9/2010, Tompkins Neil wrote:
>Hi all,
>
>Needing some advice on my tables design.
>
>Basically I am designing a soccer application, and have a table which
>contains player_bids (the values of which a player costs to be transferred
>between clubs). Can someone please offer some input on the best way in
>which I should design the financial table for each team to hold the teams
>current balance,historic financial information in terms of player wages and
>how best I should link it to the players_bids table, if I should at all ?
> Other information storage in the financial table would be things like prize
>money, gate receipts etc
>
>Thanks for any help.
>
>Cheers
>Neil

Neil,
If you are just starting out with database design, you may get some
ideas from http://www.databaseanswers.org/data_models/

Mike


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org