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 |
avg_height |
avg_weight |
| Archery |
171.3076923076923077 |
67.7500000000000000 |
| Nordic Combined |
177.1666666666666667 |
68.0833333333333333 |
| Lacrosse |
180.0000000000000000 |
84.5000000000000000 |
| Baseball |
183.1956521739130435 |
89.1956521739130435 |
| Gymnastics |
162.4562211981566820 |
56.1990291262135922 |
| Wrestling |
173.7225433526011561 |
80.8371428571428571 |
| Judo |
176.1529411764705882 |
83.4764705882352941 |
| Athletics |
177.7601010101010101 |
71.4440203562340967 |
| Canoeing |
181.3349514563106796 |
80.1262135922330097 |
| Table Tennis |
168.3333333333333333 |
62.0476190476190476 |
| Ski Jumping |
177.7083333333333333 |
64.0454545454545455 |
| Short Track Speed Skating |
170.4237288135593220 |
66.5084745762711864 |
| Cricket |
- |
- |
| Skeleton |
176.0000000000000000 |
67.5000000000000000 |
| Basque Pelota |
- |
- |
| Roque |
- |
- |
| Freestyle Skiing |
170.2916666666666667 |
68.2500000000000000 |
| Snowboarding |
168.4285714285714286 |
66.4285714285714286 |
| Bobsleigh |
180.2682926829268293 |
88.1219512195121951 |
| Golf |
- |
- |
| Water Polo |
186.1437500000000000 |
86.7857142857142857 |
| Weightlifting |
169.1022727272727273 |
84.9352427184466019 |
| Military Ski Patrol |
- |
- |
| Handball |
183.1608391608391608 |
80.7642857142857143 |
| Swimming |
179.9815195071868583 |
71.8225108225108225 |
| Figure Skating |
167.2686567164179104 |
59.0714285714285714 |
| Basketball |
191.0728744939271255 |
85.6974789915966387 |
| Boxing |
174.1655172413793103 |
67.2428571428571429 |
| Cycling |
178.1524390243902439 |
72.6770186335403727 |
| Fencing |
176.8384279475982533 |
71.6755319148936170 |
| Racquets |
- |
- |
| Curling |
172.9230769230769231 |
68.0000000000000000 |
| Rugby |
173.5263157894736842 |
77.7692307692307692 |
| Ice Hockey |
177.3239436619718310 |
78.0462962962962963 |
| Alpinism |
- |
- |
| Cross Country Skiing |
172.6470588235294118 |
65.1228070175438596 |
| Taekwondo |
179.2222222222222222 |
68.5555555555555556 |
| Shooting |
173.7218045112781955 |
76.2035398230088496 |
| Football |
176.8923766816143498 |
72.4566210045662100 |
| Alpine Skiing |
171.0000000000000000 |
69.4857142857142857 |
| Luge |
178.4000000000000000 |
80.8800000000000000 |
| Biathlon |
172.8113207547169811 |
63.3047619047619048 |
| Speed Skating |
176.9230769230769231 |
72.2957746478873239 |
| Sailing |
179.8187134502923977 |
78.0060606060606061 |
| Tennis |
183.9722222222222222 |
76.5312500000000000 |
| Hockey |
173.9230769230769231 |
69.7731958762886598 |
| Rowing |
183.5877192982456140 |
79.7346491228070175 |
| Synchronized Swimming |
169.1666666666666667 |
56.8333333333333333 |
| Softball |
170.6071428571428571 |
70.4444444444444444 |
| Polo |
- |
- |
| Equestrianism |
175.8000000000000000 |
68.2357142857142857 |
| Badminton |
182.0000000000000000 |
74.1428571428571429 |
| Modern Pentathlon |
179.5925925925925926 |
70.4444444444444444 |
| Rhythmic Gymnastics |
169.6071428571428571 |
48.4814814814814815 |
| Trampolining |
163.7500000000000000 |
57.0000000000000000 |
| Croquet |
- |
- |
| Volleyball |
188.0914634146341463 |
81.3170731707317073 |
| Tug-Of-War |
183.5000000000000000 |
90.7500000000000000 |
| Beach Volleyball |
189.1333333333333333 |
83.0666666666666667 |
| Rugby Sevens |
178.1000000000000000 |
83.5500000000000000 |
| Diving |
165.9857142857142857 |
60.2166666666666667 |
| Art Competitions |
- |
- |
| Triathlon |
179.0000000000000000 |
66.8888888888888889 |