How to structure a table for additional data if a particular value of an enum/lookup table is chosen
- by Soliah
I'd like to store additional data if a particular value is chosen in the enumerated or looked-up column in a table. The obvious option is to have an extra column in the table, but this will lead to a mostly empty column and seems to be like bad approach. Is there another option/method of doing this?