Following that model and tweaking for our own use -- it could look something like the following (assuming we want to design something simple that also works for challenges other than the HOP)
Challenges (ie. The Overall HOP Challenge)
Stages (ie. 6/4 HOP)
Stage_Segments (ie. Segments for Given stage: Bren Hill, etc. plus a Mystery Segment)
Stage_Segment_Efforts (ie. User Segment Effort data)
Inspiration? segment-challenge-dml
Following that model and tweaking for our own use -- it could look something like the following (assuming we want to design something simple that also works for challenges other than the HOP)