I have a rails application which has a table ‘cells’ which contains some
so attribute fields (related to the electrical characteristics of macros
are hooked together, instantiated in silicon and become microchips).
I want to also store the legal values for many of those attribute fields
another database table. The problem is that
- the sub-set of attributes that apply to each cell is dependent on the
of certain key cell attributes
(eg. if the value of the library attribute is ‘xx00’, then certain
fields will not apply)
- the legal values of many of the attributes will vary depending on the
of other attributes
(eg. if the value of the ‘cell_type’ attribute is ‘blah’ then the
for attribute ‘foo’ are [abc, def, ghi], otherwise they are [abc,
I get the whole notion of single inheritance tables which I will need to
what I don’t get is how I can model these dependencies in the database.
Can anyone share a similar need they had and how they handled it.