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
| noc |
gold_medal_count |
| ALG |
3 |
| ANZ |
18 |
| ARG |
63 |
| ARM |
3 |
| AUS |
252 |
| AUT |
30 |
| BAH |
15 |
| BEL |
105 |
| BLR |
21 |
| BRA |
60 |
| BUL |
33 |
| CAN |
294 |
| CHN |
147 |
| CIV |
3 |
| CMR |
12 |
| COL |
12 |
| CRO |
30 |
| CUB |
99 |
| CZE |
15 |
| DEN |
96 |
| DOM |
3 |
| ESP |
84 |
| ETH |
33 |
| EUN |
60 |
| FIJ |
6 |
| FIN |
12 |
| FRA |
546 |
| FRG |
72 |
| GBR |
687 |
| GDR |
165 |
| GEO |
3 |
| GER |
366 |
| GRE |
27 |
| HAI |
48 |
| HUN |
204 |
| INA |
6 |
| IND |
66 |
| IOA |
3 |
| IRI |
3 |
| IRL |
12 |
| ITA |
597 |
| JAM |
54 |
| JPN |
30 |
| KAZ |
9 |
| KEN |
15 |
| KOR |
63 |
| LTU |
9 |
| LUX |
3 |
| MAR |
6 |
| MEX |
27 |
| NED |
177 |
| NEP |
3 |
| NGR |
27 |
| NOR |
246 |
| NZL |
78 |
| PAK |
57 |
| POL |
39 |
| PRK |
6 |
| ROU |
120 |
| RSA |
12 |
| RUS |
207 |
| SCG |
6 |
| SLO |
6 |
| SRB |
6 |
| SUI |
105 |
| SWE |
198 |
| TCH |
42 |
| THA |
3 |
| TPE |
6 |
| TTO |
15 |
| TUR |
48 |
| UAE |
3 |
| UGA |
3 |
| UKR |
24 |
| URS |
588 |
| URU |
33 |
| USA |
1896 |
| UZB |
6 |
| YUG |
69 |
| ZIM |
18 |
