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