title: How to create database tables for a form-generator and its record?
body: <p>I am working on a form-generator, however , I was confused when attempting to create the database for it.</p>
  
  <p>The requirement is divided into backend / frontend, </p>
  
  <p>For backend, the admin can manage the form</p>
  
  <ul>
  <li>specific form name</li>
  <li>manage the form input (only input box , select box , check box are allow)
  
  <ul>
  <li>input title</li>
  <li>is required?</li>
  <li>if selectbox:
  
  <ul>
  <li>option name , value</li>
  <li>*is pop up other input when I select the value?</li>
  </ul></li>
  <li>if input box:
  
  <ul>
  <li>is numeric / string type?</li>
  </ul></li>
  </ul></li>
  </ul>
  
  <p>frontend: can store the form value</p>
  
  <p>The problem are:</p>
  
  <p>1) For the * , For example, if the user select option A , then the option C is visible , otherwise , it is hidden , how can I store the relationship? </p>
  
  <p>2) How can I store the value in this form ? If I put in one table / the value are possible to be varchar / float / integer / tinyint</p>
  
  <p>Thanks for helping <img src="https://i.stack.imgur.com/GFa0p.png" alt="enter image description here"></p>