Make DB Table for the player stats.

soohan-ahn / eagles

The web site for Tokyo Eagles.

0 stars 1 forks source link

Make DB Table for the player stats. #41

Open soohan-ahn opened 8 years ago

soohan-ahn commented 8 years ago

Retreiving the whole at_bat_batter_records and *_records table is too slow since the data has been increased. Making table will help this. The index cache such as Redis might not needed yet.

soohan-ahn commented 8 years ago

[BUG] Sort by name, back_number, team doesn't work.

soohan-ahn commented 7 years ago

Make the detailed records and saber matrix.

Tables

(game|season|total)_fielding_detail_records
- Field_inning
- Putouts
- Assists
- Errors
- Total chances (putouts + assists + errors).
- Range factors
- Passed ball
season_batter_detailed_records
- left_course_rate
- center_course_rate
- right_course_rate
- fly_ball_rate
- ground_ball_rate
- XR
- RC
- RC/7
season_pitcher_detailed_records
- BB/7
- SO/7
- SO/BB
- FIP