3 ms·
Over-normalization - one enterprise design pattern I've seen is to take fields that have basic values (which may have more attributes than just text) and create
by r00fus 10y ago
Over-normalization - one enterprise design pattern I've seen is to take fields that have basic values (which may have more attributes than just text) and create a field_values table which can be reused across objects. The key is to have a composite natural key like "field_name, value_name" so you can reuse across parent tables without creating seperate value tables for common things like status, phase, etc.
It allows more configurability as well - you could have a UI to control/audit all such values and allow for easy external mapping.