College Football Players And Their Stats (was Database Design Help)

I'm trying to design a college football players database and their statistics, and I have tables defined. However, I've hit a roadblock and could use some advice.

What I am trying to do is:

1) I have a table with a college football prospect filled with information. I name a table named Prospects.

2) I want to keep their stats for the year, which could include items like PassAttempts, Completions, Touchdowns, etc.

Now, I could just have a table named Offense with PassAttempts, Completions, touchdows, etc. Then, have a table called Defense with columns like sacks, forcedfumbles, etc. Along those lines, a table named Kicker with colunms such as FGmade, FGattempted, etc.

For example:

Table Offense
PassAttempts int notNull
PassCompeted int notNull

However, I kinda see this would be bad if later I need to add a column to the table for a new stat as i have to go in a add data to exixting rows. So, what I think I need is instead of defining these stats as columns that I need to define them as rows somehow.

So, I have a Prospects table and a Statistics table. This looks to me like a many to many relationship as a prospect can have many statistics and a statistics can have many players. So I defined a junction table which includes the primary for from both tables to create two, one t many relationships.

I also have a few other tables I'm using to break it down.

Table: StatOccurance (Can be something like SeasonStat, BowlGame, AllStarGame, etc.)

Table: StatType (Can be PassCompleted, Fumbles, FieldGoalAttempts, Touchdowns, etc.).

Table: StatCategory (Can be Offense, Defense, Kicker, Punter, etc.).

Anyway, any advice would be appreciated on how to piece these together efficiently. I have a Word document with my tables you can look at that show the fields and relationships. In particular, in my Statistics table I have StatValue where the actual statistic value will be held but I don't know how to set its type? What if a stat is numeric, character, or even something text like a height 6' 4". I can do all this if I were to put offense, defense, etc. in their own table, but I don't think that's the way to go even though I don't know exactly how to explain why. I know it has something to do with "What if I add a new offensive stat later after the table is populated" but I don't know how else to specify the types of individual statistics.

Don't laugh if it's garbage as I'm using this as a learning process. I may not have explained it very well, but you can look at a diagram I put here to get an idea of what I'm trying to do.

Stat Data

Thanks!