How to structure a table for additional data if a particular value of an enum/lookup table is chosen

Posted by Soliah on Stack Overflow See other posts from Stack Overflow or by Soliah
Published on 2010-04-02T01:18:38Z Indexed on 2010/04/02 1:23 UTC
Read the original article Hit count: 167

Filed under:

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?

© Stack Overflow or respective owner

Related posts about database-design