ruby on rails - Struggling with a model because of a lot of data -

i'm building app write wine tasting notes, , have translate tasting framework (only first page) model.

it's lot of data , i'm not sure how proceed. tried sketch possible solution in this spreadsheet.

what suggest do? should create 1 model (wine) column each wine characteristic?

thanks!

p.s. i'm learning web development, sorry if question sounds trivial.

perhaps not direct answer question here's few notes nevertheless:

i'd wine tasting, go combination of selects, tags , simple free-text.

this railscast should give introduction acts-as-taggable-on gem tagging.

one thing may handy when modelling db @ several wine tasting 'forms' filled out , see if can see pattern. palate/acidity expect value 1 of light/medium/high, whereas conclusion/identity pretty anything.

you'll need find right balance between restricting , allowing user input. i'd expect users happier free-text , feeling more restricted select/radio boxes. on other hand, easier (for you) change select box free text, rather other way around. not mention searching easier selects or tags.

i don't think question trivial , think should try , see. , design ability change in mind.