In relation to sports, for example a football (soccer) match, a team can either play home or away. For a database design I am looking for a single word to denote this "property", where a team plays, but am struggling to find such a word. Does anyone here have a suggestion?
You could use side; both home side and away side (with or without hyphen) are common designations:
(plural home sides)
- (sports) the team that plays at home (in their own stadium)
- away side
Even if the teams play on neutral ground (for instance during the World Cup), one of the teams is usually the 'virtual' home team and mentioned first in the schedule.
"Host" with values true or false would work nicely in your case. And since you are building a database, then a bit field is the best, since it takes the least amount of disk space. Also if that field is supposed to tell you at whose stadium the game took place at, so it means which team hosted the game. Hence host is the simplest and easiest to understand name of the field in your database.
UPDATE: Another choice is to make this field called "Location" and input as arguments the name of the team that owns the stadium, or the name of the stadium.
In American English, "site" would be the best choice. I say this because there are actually three choices: "home", "away", and "neutral site". "Site" is the standard noun for "neutral" to modify in this context.
"Site" is a conveniently short name. For purposes of database results, "neutral site" can be abbreviated to "neutral" or "neither". For purposes of database storage, "home", "away", and "neutral" can be abbreviated to arbitrary letters or numbers. For example, "H", "A", and "N". You might want to have a fourth value (or null) to indicate that the site is unknown.
Some stadiums host multiple teams in the same sport. For example, the NFL's New York Giants and New York Jets play at the same stadium in New Jersey. They play a game against each other in roughly one out of four years.
Some leagues pretend that every game has both a home team and an away team, even if the game is physically at a neutral site. Which team is the theoretical home team can affect the colors of jerseys that the players wear, which team's season ticket holders get priority to attend the game, who is responsible for hosting the game if the neutral site cannot, and how many of the team's other games can be actual home games. In baseball games, some of the rules depend on which team is the home team.
Thus, you might want to avoid having a single field for "site". You could instead have a "Home" or "IsHome" (or "Away" or "IsAway") boolean field, which indicates which team is the theoretical home (or away) team, and have another "Neutral" or "NeutralSite" boolean field that indicates whether the site is actually at a place that both teams are similarly (un-)familiar with.