so i have a multi-part problem that im not quite good enough to wrap my hands around yet. maybe someone can offer me some help.
i have a rails app that among other things, tracks orders and reviews. now i'm trying to add some quality-control functionality through inspection_sheets...
ideally, an inspection sheet is composed of its associated order_id, and (im assuming the right way to do it) has_many inspection_rows... each inspection_row its inspection_sheet_id.. and then multiple user defined fields defining what i want to inspect for each job...
each job will have a variety of things needing to be inspected and they're all defined at runtime...
for example... a min-max field which will take two numbers, a minimum and a maximum passing value.. if the number given is within the passing range good.. if its not, i'll still accept it.. i just want to format it differently upon viewing it later.. that part i dont think is so hard...
anyhow, another type will be boolean, which will either be a go/no- go.. good/bad.. on/off..etc.. again, thats simple...
but from a design aspect.. the main question is, how do i pull all of this together and at creation time - allow myself to choose between what type of field it is? do i maintain two separate tables for boolean values and min-max values? what about adding new types down the line?
alright. im fairly certain that this post is pretty drawn out as it is.. so if anyone wants to offer any advice, i'd be happy to elaborate further...
thanks a bunch for your time. -fjm
