to pivot or not to pivot - schema design question
MySQL should not have trouble handling a large table like that.  You have it indexed (because of the foreign keys) so most queries against the table should use one of the indexes and be fairly fast even if there are a huge number of rows in the table.