Definitions and General Structure
qualifying_teams, qualifying_athlete: teams and athletes that actually qualify and participate in the Olympic Games (competitor was too broad, if we in the future wanted to represent those that did not make it past qualifications or those that did but only as reserves)
olympic_event_types: [properties: schedule, qualifying_gymnast, qualifying_team, medals, results]
gymnastics_artistic_event_types
all-around_team [properties: results[team, total_score, rank], events]
all-around_individual [properties: results[gymnast, total_score, rank]]
floor_exercises [properties: results[difficulty_score, execution_score, penalty, total_score]]
horizontal_bar [properties: results[difficulty_score, execution_score, penalty, total_score]]
parallel_bars [properties: results[difficulty_score, execution_score, penalty, total_score]]
pommel_horse [properties: results[difficulty_score, execution_score, penalty, total_score]]
rings [properties: results[difficulty_score, execution_score, penalty, total_score]]
vault [properties: results[difficulty_score, execution_score, penalty, vault, vault_score]]
gymnastics_rhythmic_event_types
all-around_team [properties: results[qualifying_team, total_score]]
all-around_individual [properties: results[qualifying_gymnast, total_score, rank, [event, score, penalty]]]
gymnastics_trampoline
all-around_individual [properties: results[gymnast, difficulty_score, execution_score, penalty, flight_score, total_score
artistic event types
type: all-around team (men and women)
genls: event
isa: 2012_mens_artistic_all_around_team
schedule: July 30th, North_Greenwich_Arena
qualifying_teams: 2012_mens_China_gym_team, 2012_mens_Japan_gym_team
medals: [[qualifying_team: 2012_mens_China_gym_team, medal: Gold],
[qualifying_team: 2012_mens_Japan_gym_team, medal: Silver]]
results: [[qualifying_team: 2012_mens_China_gym_team, total_score: 275.997, rank: 1]]
events: 2012_mens_floor_gymnastics, 2012_mens_pommel_horse, 2012_mens_rings, 2012_mens_vault, 2012_mens_parallel_bars, 2012_mens_horizontal_bar
type: all-around individual (men and women)
genls: Event
isa: 2012_womens_all_around_individual
schedule: ....
qualifying_gymnast: Gabby_Douglas
medals: [[qualifying_gymnast: Gabby_Douglas, medal: Gold], ...]
results: [[qualifying_gymnast: Gabby_Douglas, total_score: 62.232, rank: 1], ...]
type: floor_exercises (men and women)
genls: event
isa: 2012_mens_floor_gymnastics
qualifying_gymnast: Zou_Kai, Kohei_Uchimura, ....
medals: [[qualifying_gymnast: Zou_Kai, medal: Gold],
[qualifying_gymnast: Kohei_Uchimura, medal: Silver]], ....
results: [[qualifying_gymnast: Zou_Kai, difficulty_score: 6.900, execution_score: 9.033, penalty: 0, total_score: 15.933]
[qualifying_gymnast: Kohei_Uchimura, difficulty_score: 6.700, execution_score: 9.100, penalty: 0, total_score: 15.800]]
type: horizontal bar (men)
isa: 2012_mens_horizontal_bar
qualifying_gymnast: Epke_Zonderland, Zhang_Chenglong, ...
medals: [[gymnast: Epke_Zonderland, medal: gold],
[gymnast: Zhang_Chenglong, medal: silver], ...
results: [[gymnast: Epke_Zonderland, difficulty_score: 7.500, execution_score: 8.466, penalty: 0, total_score: 15.966], ...]
type: parallel bars (men)
type: pommel horse (men)
type: rings (men)
type: vault (men and women)
isa: 2012_mens_vault
qualifying_gymnast: Denis_Ablyazin, Yang_Hak_Seon, ...
medals: [qualifying_gymnast: Denis_Ablyazin, qualifying_gymnast: Yang_Hak_Seon, ...]
results: [[[gymnast: Epke_Zonderland, difficulty_score: 7.000, execution_score: 9.300, penalty: 0, vault: 1, vault_score: 16.300]
[gymnast: Epke_Zonderland, difficulty_score: 7.200, execution_score: 9.233, penalty: 0, vault: 2, vault_score: 16.433] total_score: 16.366], ...]
type: balance beam (women)
type: uneven bars (women)
rhythmic event types
type: individual_all_around_rhythmic
isa: 2012_individual_all_around_rythmic
qualifying_gymnast: Yevgeniya_Kanayeva, ....
medals: [[qualifying_gymnast: Yevgeniya_Kanayeva, medal: gold], ...]
events: ball_rythmic_event, hoop_rythmic_event, clubs_rythmic_event, ribbon_rythmic_event
results: [[qualifying_gymnast: Yevgeniya_Kanayeva, total_score: 116.900, rank: 1, [event: ball_rythmic_event, score: 29.200, penalty: 0], [event: hoop_rythmic_event, score: 29.350, penalty: 0]], ...]
type: group_all_around_rhythmic
isa: 2012_group_all_around_rhythmic
qualifying_teams: 2012_Russian_rhythmic_team, ...
medals: [[qualifying_team: 2012_Russian_rhythmic_team, medal: Gold],...]
results: [[qualifying_team: 2012_Russian_rhythmic_team, total_score: 56.375, rank: 1]]
<!--it isn't clear to me how much detail is needed here. For the above results, we have additional data: [5 Balls, 28.375 score, 0 penalty] [3 Ribbons, 2 Hoops, 28.000 score, penalty 0]-->
trampoline event types
type: individual_trampoline (men's and women's)
isa: 2012_mens_trampoline
qualifying_gymnast: Dong_Dong ...
medals: [[qualifying_gymnast: Dong_Dong, medal: gold], ...]
results: [[gymnast: Dong_Dong, difficulty_score: 17.800, execution_score: 27.100, penalty: 0, flight_score: 18.090, total_score: 62.990], ...]