The part_category_id and the customer_type_id fields need a bigger presence. Both of those fields have proved to be major sections in multiple places. Currently, we only record those fields in certain places (true one-to-many database logic). However, to help with certain reports, it would be so helpful if we were to cascade those values to those sub tables. It would save so many links and table joins. It would also allow for faster grouping based off a single table vs joining multiple tables and then showing the same results (heavier load). Anyways, those two fields have been huge system dividers and things that people want to filter and search by. Interesting.