|
Bat Boy
Join Date: May 2025
Posts: 5
|
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
Quote:
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);
|
|