In a more dynamic environment where you could manage values in a controlled manner, how could you validate values ? One idea is to make a DB table dedicated to

In a more dynamic environment where you could manage values in a controlled manner, how could you validate values ? One idea is to make a DB table dedicated to enumerations and then use foreign key constraints. Define a unique namespace for each set of enumerated values, and catch foreign key constraint failures on DB writes.