Award Values

[fantom1979]

I already listed the values for streaks in the player_streak table, here are the values for awards in the players_awards table. Hopefully it will save someone some time.

0=player of the week
1=pitcher of the month
2=batter of the month
3=rookie of the month
4=pitcher of the year
5=most valuable player
6=rookie of the year
7=fielder of the year
9=all-star


I do not have any players with an award value of 8. I currently do not have any hall of famers in my league so it could possibly be that, or maybe it is the non existant manager of the year award.

[BigCountryBumgarner]

18 years later I just want you to know....you saved me a lot of time sifting through SQL data trying to figure this out. I spent like 40 minutes on it. My new mod appreciates it

[jlangjr]

Adding on here. I think I figured out the others

11=silver slugger
13=reliever of the year
14=world series champion
15=playoff series mvp

not sure about 10 or 12, but don't have any in my league.

Wrote some SQL for this, award_level is my personal level of prestige for these awards

DROP TABLE IF EXISTS award_mapping;

CREATE TABLE award_mapping (
award_id INT PRIMARY KEY,
award_name VARCHAR(100) NOT NULL,
award_level INT NOT NULL
);

INSERT INTO award_mapping (award_id, award_name, award_level) VALUES
(0, 'Player of the Week', 0),
(1, 'Pitcher of the Month', 1),
(2, 'Batter of the Month', 1),
(3, 'Rookie of the Month', 1),
(4, 'Platinum Pitcher', 5),
(5, 'Golden Guy', 5),
(6, 'Copper Comet', 4),
(7, 'Diamond Defender', 3),
(9, 'All-Star', 2),
(11, 'Bronze Batter', 3),
(13, 'Ruby Reliever', 4),
(14, 'World Series Champion', 0),
(15, 'Playoff Series MVP', 1);