Hi I have a table that contains league standings type information for a soccer league. For example
season_id round_id team_id league_id home_won home_draw home_lost home_goals home_conceded away_won away_draw away_lost away_goals away_conceded Basically each row contains each league's round results for each team. From here I can display the league standings for each round for each league. My question is how / what is the best way to restrict incorrect data input apart from a coding issue/bug - e.g I need to ensure that for each round a team can only have either a value in the fields home_won or home_draw or home_lost or away_won or away_draw or away_lost as a example. Or is this best coded within my application ? Cheers Neil
