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
| sport_name |
total_medals |
| Athletics |
2625 |
| Rowing |
1902 |
| Swimming |
1698 |
| Fencing |
1176 |
| Gymnastics |
1146 |
| Hockey |
1128 |
| Football |
1041 |
| Sailing |
954 |
| Basketball |
795 |
| Ice Hockey |
774 |
| Cycling |
762 |
| Water Polo |
726 |
| Canoeing |
702 |
| Shooting |
699 |
| Wrestling |
681 |
| Equestrianism |
636 |
| Boxing |
570 |
| Volleyball |
504 |
| Handball |
492 |
| Cross Country Skiing |
387 |
| Biathlon |
333 |
| Weightlifting |
321 |
| Tennis |
276 |
| Diving |
273 |
| Speed Skating |
273 |
| Figure Skating |
267 |
| Judo |
264 |
| Bobsleigh |
207 |
| Short Track Speed Skating |
186 |
| Archery |
177 |
| Rugby |
165 |
| Alpine Skiing |
141 |
| Baseball |
138 |
| Synchronized Swimming |
108 |
| Modern Pentathlon |
102 |
| Ski Jumping |
90 |
| Rhythmic Gymnastics |
84 |
| Softball |
84 |
| Taekwondo |
81 |
| Luge |
75 |
| Art Competitions |
75 |
| Cricket |
75 |
| Freestyle Skiing |
72 |
| Polo |
69 |
| Table Tennis |
63 |
| Rugby Sevens |
60 |
| Tug-Of-War |
57 |
| Lacrosse |
54 |
| Curling |
51 |
| Beach Volleyball |
48 |
| Badminton |
48 |
| Nordic Combined |
42 |
| Snowboarding |
42 |
| Triathlon |
27 |
| Trampolining |
24 |
| Racquets |
15 |
| Golf |
12 |
| Skeleton |
12 |
| Alpinism |
12 |
| Military Ski Patrol |
9 |
| Croquet |
6 |
| Basque Pelota |
3 |
| Roque |
3 |
