This view would be grouped by event/date, showing all the individual results recorded for that event.
Currently the racing team information form has free form event name input, which makes automatic display of results grouped by event problematic. An alternative would be to have a table (rt_event) which has event name, distance, and location (but not date). The user form would provide a search function to find an event which may already exist, or allow the user to create a new one. The events in this new table would be linked from the racing team information form, and possibly the racing team application.
Note rt_info and rt_application tables both use rt_result table to store the results, so it would be convenient if both forms have access to rt_event.
Similarly, the awards are currently free form. Having said that, this is less problematic as we don't have any desire to group results by awards.
[ ] add rt_event table (name, distance, location)
[ ] analyze dump of rt_result table to find set of actual events which can be mapped from the user input. E.g., Sheppard Pratt Frederick Turkey Trot, Way Station Turkey Trot, Waystation Turkey trot 5k, 2018 Way Station Turkey Trot, Frederick Turkey Trot 5K are all the same event. Create mapping to a common event name for all occurrences of similar sets of free form event names
[ ] populate rt_event table as part of the database conversion
[ ] convert all rt_result entries to use rt_event (requires offline mapping of rt_result.eventname/distance to rt_event table record)
update racing team information form (and application?) to use standardized event names
[ ] provide search function for event name
[ ] allow user to pick from possible events from search results (displays event name, distance, location), or create new
[ ] provide view which groups rt_result entries by rt_event entry, most recent first
This view would be grouped by event/date, showing all the individual results recorded for that event.
Currently the racing team information form has free form event name input, which makes automatic display of results grouped by event problematic. An alternative would be to have a table (rt_event) which has event name, distance, and location (but not date). The user form would provide a search function to find an event which may already exist, or allow the user to create a new one. The events in this new table would be linked from the racing team information form, and possibly the racing team application.
Note rt_info and rt_application tables both use rt_result table to store the results, so it would be convenient if both forms have access to rt_event.
Similarly, the awards are currently free form. Having said that, this is less problematic as we don't have any desire to group results by awards.