Hi

I've a soccer application consisting of managers, teams players and fixtures/results. Basically each manager will get points for each game which will depend on the result.

What would be the best table design bearing in mind that a manager can move to a different club.

My thought was to have a field in the fixtures/results table for the manager points but i think that I will also need a users field so that I can remember which points belong to which manager.

Is this the correct approach??

Cheers Neil

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to