Help With model Idea Setup

I have played with this idea as many have seen me post over the past few days and since nothing is going as planned I have decided to start the idea from scratch and would like some feedback on how you would do it.

 

I simply wanted to add an additional field to my join table of profile and skills, profile HABTM skills so i have given up on that since that came to a very disappointing conclusion.

 

So this is my new idea. I want my skills list to be just a set of options admin can enter and a user can select from but selecting them will come in a form of a select drop down box of "Years"

 

So the form would end up looking like:

 

skill1 [dropdown of years]

skill2 [dropdown] and so on

 

dropdown would save the year_id so the "years" table would be id, range

 

So the data being saved would be profile_id, skill_id and year_id in profiles_skills?  but make profiles_skills a belongTo and hasMany relationship not a HABTM?

Add to add just a little more fun to my attempt I want to include an ajax form made of a single input and the year drop down to add skills that are not in the list available to select from in case a user has something not in the list. So my guess is this would be

additional_profiles_skills which has

profile_id,

year_id,

name?

 

Does this make sense? Right names and such?

 

Thanks

 

Dave