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
