The table measure has a house_id field and a foreign relation to the house table. This is not correct, since the playerround table already has a house_id for a relation to the house table. Players can only take measures for their current house, not for another house -- therefore, to avoid taking a measure for the wrong house, the house_id should be removed from the measure table.
The table
measure
has ahouse_id
field and a foreign relation to thehouse
table. This is not correct, since theplayerround
table already has ahouse_id
for a relation to thehouse
table. Players can only take measures for their current house, not for another house -- therefore, to avoid taking a measure for the wrong house, thehouse_id
should be removed from themeasure
table.