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
| year |
city |
total_medals |
| 1896 |
Athina |
93 |
| 1900 |
Paris |
1359 |
| 1904 |
St. Louis |
357 |
| 1906 |
Athina |
378 |
| 1908 |
London |
642 |
| 1912 |
Stockholm |
639 |
| 1920 |
Antwerpen |
873 |
| 1924 |
Paris |
597 |
| 1924 |
Chamonix |
87 |
| 1928 |
Amsterdam |
534 |
| 1928 |
Sankt Moritz |
51 |
| 1932 |
Los Angeles |
450 |
| 1932 |
Lake Placid |
45 |
| 1936 |
Berlin |
537 |
| 1936 |
Garmisch-Partenkirchen |
99 |
| 1948 |
London |
621 |
| 1948 |
Sankt Moritz |
66 |
| 1952 |
Helsinki |
585 |
| 1952 |
Oslo |
111 |
| 1956 |
Melbourne |
573 |
| 1956 |
Cortina d'Ampezzo |
93 |
| 1956 |
Stockholm |
18 |
| 1960 |
Roma |
591 |
| 1960 |
Squaw Valley |
84 |
| 1964 |
Tokyo |
624 |
| 1964 |
Innsbruck |
96 |
| 1968 |
Mexico City |
537 |
| 1968 |
Grenoble |
90 |
| 1972 |
Munich |
666 |
| 1972 |
Sapporo |
105 |
| 1976 |
Montreal |
825 |
| 1976 |
Innsbruck |
111 |
| 1980 |
Moskva |
813 |
| 1980 |
Lake Placid |
135 |
| 1984 |
Los Angeles |
981 |
| 1984 |
Sarajevo |
90 |
| 1988 |
Seoul |
909 |
| 1988 |
Calgary |
81 |
| 1992 |
Barcelona |
1032 |
| 1992 |
Albertville |
156 |
| 1994 |
Lillehammer |
192 |
| 1996 |
Atlanta |
1020 |
| 1998 |
Nagano |
228 |
| 2000 |
Sydney |
1044 |
| 2002 |
Salt Lake City |
282 |
| 2004 |
Athina |
1116 |
| 2006 |
Torino |
309 |
| 2008 |
Beijing |
1191 |
| 2010 |
Vancouver |
249 |
| 2012 |
London |
1251 |
| 2014 |
Sochi |
297 |
| 2016 |
Rio de Janeiro |
1278 |
