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
| city |
| Mexico City |
| Amsterdam |
| Los Angeles |
| Barcelona |
| London |
| Paris |
| Beijing |
| Sydney |
| Montreal |
| Tokyo |
| Berlin |
| St. Louis |
| Atlanta |
| Roma |
| Athina |
| Seoul |
| Munich |
| Helsinki |
| Moskva |
| Stockholm |
| Antwerpen |
| Rio de Janeiro |
| Melbourne |
