Best way to handle column that doesn't conform to one particular type
The approach you are proposing is workable but informal.  A more formal approach can be found in my answer to this question.

The basic pattern is called a Property Bag.