title: Storing JSON data in a database column
body: <p>I have a scenario where a "parameter_id" is one column in database and other column is "parameter_value". 
  Now - "parameter_value" can contain key-value pairs which are mostly parameter's metadata apart from ONE ACTUAL VALUE. Is it good idea to store this structure as JSON in "parameter_value" column ? This catch here is the number of metadata key-value pairs may vary for each parameter. Will JSON be a good design to store data ?</p>
  
  <p>I am providing data sample below</p>
  
  <p>eg. </p>
  
  <pre><code>parameter_id  :::: parameter_value
  ============================
  
  distance      :::: {value : 10 , run : 5, walk : 5 }
  ------------------------------------------
  
  bloodPressure :::: {value : 85 , systol : 120 , disatol : 80, beforeExam : 180, afterExam : 60 }
  ------------------------------------------------------------------------
  </code></pre>