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
| anzahl_goldmedaillen |
| 8136 |
