It's pronounced Diane. I do data architecture, operations, and backend development. In my spare time I maintain Massive.js, a data mapper for Node.js and PostgreSQL.
and use check constraints to ensure that only one value column is ever filled (as long as you're not using MySQL which doesn't actually implement them). But that's still probably overkill if you don't have to retrieve values that frequently. Simple kludges are the best kludges.
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
You could set up your table like this:
and use check constraints to ensure that only one value column is ever filled (as long as you're not using MySQL which doesn't actually implement them). But that's still probably overkill if you don't have to retrieve values that frequently. Simple kludges are the best kludges.