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 |
year |
num_athletes |
| Calgary |
1988 |
1470 |
| London |
1908 |
2086 |
| Chamonix |
1924 |
320 |
| Seoul |
1988 |
8540 |
| Garmisch-Partenkirchen |
1936 |
677 |
| Sankt Moritz |
1948 |
684 |
| London |
2012 |
10639 |
| Athina |
2004 |
10698 |
| Sapporo |
1972 |
1047 |
| Vancouver |
2010 |
2554 |
| Paris |
1924 |
3384 |
| Montreal |
1976 |
6117 |
| Rio de Janeiro |
2016 |
11296 |
| Paris |
1900 |
1596 |
| Oslo |
1952 |
707 |
| Helsinki |
1952 |
4964 |
| Lake Placid |
1980 |
1093 |
| St. Louis |
1904 |
873 |
| Nagano |
1998 |
2209 |
| Atlanta |
1996 |
10487 |
| Grenoble |
1968 |
1190 |
| Lake Placid |
1932 |
259 |
| Cortina d'Ampezzo |
1956 |
837 |
| Sankt Moritz |
1928 |
469 |
| Melbourne |
1956 |
3206 |
| Berlin |
1936 |
4489 |
| Los Angeles |
1984 |
6840 |
| Stockholm |
1912 |
2520 |
| Athina |
1896 |
191 |
| Amsterdam |
1928 |
3291 |
| Sochi |
2014 |
2818 |
| Los Angeles |
1932 |
1943 |
| Tokyo |
1964 |
5161 |
| Roma |
1960 |
5405 |
| Antwerpen |
1920 |
2727 |
| Mexico City |
1968 |
5589 |
| Sydney |
2000 |
10774 |
| Munich |
1972 |
7173 |
| Sarajevo |
1984 |
1299 |
| London |
1948 |
4498 |
| Barcelona |
1992 |
9492 |
| Athina |
1906 |
893 |
| Innsbruck |
1976 |
1166 |
| Moskva |
1980 |
5306 |
| Innsbruck |
1964 |
1135 |
| Lillehammer |
1994 |
1755 |
| Stockholm |
1956 |
164 |
| Squaw Valley |
1960 |
665 |
| Torino |
2006 |
2510 |
| Beijing |
2008 |
11045 |
| Salt Lake City |
2002 |
2429 |
| Albertville |
1992 |
1847 |
