I strongly suggest that you make a separate table for the manager <-> team relationship, so you can keep a history. Put a date-stamp in there. This might come in handy as you get further into your design.
I ran into this problem when one of our sales reps moved from one office to another, and took their sales history with them! That was a mess to unscramble. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com >-----Original Message----- >From: Neil Tompkins [mailto:neil.tompk...@googlemail.com] >Sent: Tuesday, August 31, 2010 3:48 PM >To: mysql@lists.mysql.com >Subject: Database design help > >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=je...@gii.co.jp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org