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 |
min_age |
max_age |
| Alpine Skiing |
17 |
32 |
| Alpinism |
27 |
57 |
| Archery |
17 |
55 |
| Art Competitions |
20 |
73 |
| Athletics |
16 |
38 |
| Badminton |
19 |
32 |
| Baseball |
20 |
37 |
| Basketball |
18 |
37 |
| Basque Pelota |
26 |
26 |
| Beach Volleyball |
21 |
38 |
| Biathlon |
20 |
40 |
| Bobsleigh |
15 |
40 |
| Boxing |
17 |
31 |
| Canoeing |
18 |
40 |
| Cricket |
24 |
40 |
| Croquet |
15 |
15 |
| Cross Country Skiing |
19 |
43 |
| Curling |
24 |
47 |
| Cycling |
18 |
43 |
| Diving |
15 |
33 |
| Equestrianism |
20 |
56 |
| Fencing |
17 |
50 |
| Figure Skating |
14 |
38 |
| Football |
16 |
36 |
| Freestyle Skiing |
20 |
33 |
| Golf |
17 |
41 |
| Gymnastics |
14 |
45 |
| Handball |
19 |
39 |
| Hockey |
17 |
41 |
| Ice Hockey |
17 |
41 |
| Judo |
18 |
33 |
| Lacrosse |
22 |
32 |
| Luge |
19 |
42 |
| Military Ski Patrol |
20 |
26 |
| Modern Pentathlon |
21 |
34 |
| Nordic Combined |
19 |
36 |
| Polo |
21 |
48 |
| Racquets |
19 |
25 |
| Rhythmic Gymnastics |
15 |
24 |
| Roque |
37 |
37 |
| Rowing |
13 |
58 |
| Rugby |
20 |
33 |
| Rugby Sevens |
20 |
29 |
| Sailing |
15 |
56 |
| Shooting |
17 |
61 |
| Short Track Speed Skating |
17 |
31 |
| Skeleton |
25 |
41 |
| Ski Jumping |
18 |
31 |
| Snowboarding |
18 |
36 |
| Softball |
21 |
38 |
| Speed Skating |
17 |
37 |
| Swimming |
13 |
32 |
| Synchronized Swimming |
19 |
31 |
| Table Tennis |
19 |
35 |
| Taekwondo |
17 |
30 |
| Tennis |
16 |
40 |
| Trampolining |
19 |
31 |
| Triathlon |
22 |
34 |
| Tug-Of-War |
24 |
42 |
| Volleyball |
17 |
37 |
| Water Polo |
18 |
38 |
| Weightlifting |
19 |
34 |
| Wrestling |
19 |
40 |
