Training
| Tabelle |
Spalten |
Fremdschlüssel |
| athlete |
(
aid
,
name
,
gender
)
|
|
| athlete_team |
(
aid
,
tid
,
gid
)
|
aid
»
athlete.aid
tid
»
team.tid
gid
»
games.gid
|
| discipline |
(
did
,
sid
,
name
)
|
sid
»
sport.sid
|
| games |
(
gid
,
year
,
season
,
city
)
|
|
| medals |
(
aid
,
gid
,
did
,
age
,
height
,
weight
,
medal
)
|
aid
»
athlete.aid
gid
»
games.gid
did
»
discipline.did
|
| sport |
(
sid
,
name
)
|
|
| team |
(
tid
,
noc
,
team
)
|
|
DB: PostgreSQL
Legende: TABELLE, PRIMÄRSCHLÜSSEL, FREMDSCHLÜSSEL
| city |
num_games |
| London |
3 |
| Athina |
3 |
| Innsbruck |
2 |
| Lake Placid |
2 |
| Paris |
2 |
| Stockholm |
2 |
| Sankt Moritz |
2 |
| Los Angeles |
2 |
| St. Louis |
1 |
| Sochi |
1 |
| Munich |
1 |
| Moskva |
1 |
| Torino |
1 |
| Cortina d'Ampezzo |
1 |
| Calgary |
1 |
| Amsterdam |
1 |
| Lillehammer |
1 |
| Barcelona |
1 |
| Grenoble |
1 |
| Albertville |
1 |
| Montreal |
1 |
| Chamonix |
1 |
| Vancouver |
1 |
| Squaw Valley |
1 |
| Sapporo |
1 |
| Atlanta |
1 |
| Roma |
1 |
| Seoul |
1 |
| Helsinki |
1 |
| Mexico City |
1 |
| Oslo |
1 |
| Antwerpen |
1 |
| Rio de Janeiro |
1 |
| Melbourne |
1 |
| Garmisch-Partenkirchen |
1 |
| Sarajevo |
1 |
| Nagano |
1 |
| Beijing |
1 |
| Sydney |
1 |
| Salt Lake City |
1 |
| Tokyo |
1 |
| Berlin |
1 |
