I've been reading and searching the posts for a list of the various tables and variables in the database, what they are named and what each is for.
For example, I've seen DYN_cyclist and DYN_contract_cyclist in posts. While I can sort of figure out what these are for, I'd like to see a more complete list.
Has a list ever been developed? If so, is there a link to it?
https://baseportal...M/Overview
I just know this one, Lachi created in 2008 I think. There are some German parts in it, so you might use a translator. But it shouldn`t be that hard to understand.
Another way to 'demistify'the database is just follow the linked tabled. By that i mean u have to realize any column starting with fk(foreign key) means it's linked to another table. If u don't get a certain column the columns in the parent(or linked) table usually tells u much more. As an sttraightforward example fkIDteam is linked to the dyn_team table. Also i think lachi made some excel sheet wich denote the changes made from pcm09 to pcm10. It's handy if u wanna search for a certain column and/or parent table.
It is called bonus_fitness so it has nothing to do with stats but only fitness.
I think these values are only used if a rider is injured or in a similar special status. What happened to these riders?
And more importantely:
Why are you looking these values up?
What do you really want to edit?
It also happens without injuries with me.
I always thought that this is some kind of bonus for rider with a special season high.
There are 10 numbers. January - Octobre -> 10 months
So a Contador for example has always a +2 in July, so he is better within the Tour. But therefore -1 or -2 in Septembre and Octobre.
Same for Nibali with +2 during the Giro.
Maybe it`s the nationality bonus.?
But if so, it would be better if every rider would have this bonus and not just the 50 best or most famous rider.
@ Lachi - nothing happened to the riders as its only the 3rd of Jan in my save. I wasn't actually looking up that column, it was next to a column I was looking at (favourite race I think) and it piqued my interest.
@ roturn - that makes a lot of sense, as the first rider would get a fitness bonus in July for the Tour, and the sencond in april for the classics!
