search for: mid_id

...of having to add or delete properties of one of the above categories and having to process every row in the entire table. I''m trying to get my head around the best way to do this. I''d like to break it out via composition, but having a Autos table with an suv_id, mini_id, mid_id, and sports_id (for all possible combos) seems like really bad design. I suppose I could have the Autos table have a sub_type_id and sub_type column, and somehow use this to map. However, I''m unsure how to go about this...composed_of doesn''t seem to be designed with this si...