[Data-modeling] Help. I am getting bogged down in the Mountains of the Tour de France, and the rest day is almost over.

[Gordon Mackenzie]

I am unsure if I am able to do what I want to do for capturing the  
King of the Mountains (Mountains Classification) competition in the  
2009 Tour de France.

http://www.freebase.com/type/schema/base/peleton/road_bicycle_race_climbs

For every stage of the 3 week race, I want to capture the significant  
climbs where the first few riders who reach the designated KOM point  
get points awarded. The daily leader gets to proudly (and probably  
very tiredly) wear on the next stage race day the KOM/MC jersey (Red  
Polka dots on a white jersey).

I most notably want to have:

      mountain pass/mountain location

      type of climb (category)

      winners and the points awarded to each rider

So if I make this a mediator (CVT) in client, everything seems to  
display as I want it, except the cyclists. the only way I could figure  
out how to link cyclist to points won is another CVT. However there is  
no way to add the data for the awarded points from Road Bicycle Race  
climbs edit windows, just adding the riders. I would have to edit the  
road_bicycle_race_mountain_points_awarded CVT itself to add the points  
awarded to each rider.

Is this just too much? Should I be happy to just list the riders in  
winning order? link to the basic competition type from Mountain points  
winners? I do have a tendency to over design and get too intricate  
(precious) in my schema design.

Example topic doconnor and I were working on:

http://www.freebase.com//edit/topic/guid/9202a8c04000641f800000000c684163

~ Gordon

<<< gordon at metaweb.com >>>