title: Dynamic Form and Database Schema
body: <p>I did a quick check and I could not find any questions similar to the one I am about to ask. I wish I could have been more specific in the title as it seems like a question that has been answered just shy of a million times.</p>
  
  <p>I currently am having the dilemma of not knowing how to setup a schema for the following problem for a web app:</p>
  
  <p>I have an online form that has users order custom tshirts with the following fields: Size, Color, Pocket.</p>
  
  <p>Each user in the system can have different options from the first and the fields are dynamically generated</p>
  
  <p>Examples:
  User 1: Size[Small or Medium], Color[Grey or Black], Pocket[Square or Rectangle]</p>
  
  <p>User 2: Size [Medium or Large], Color[Blue or Red], Pocket[Square or Triangle]</p>
  
  <p>Every user can have completely different options and the options for the size, color and pocket are independent of each other.</p>
  
  <p>Is this a possible solution to this problem?</p>
  
  <p>Table:</p>
  
  <p>id | user_id | Size | Size_options | Color | Color_options | Pocket | Pocket_options</p>
  
  <p>I feel there is a better way to break these out even more and would be nice to have field for option value.</p>
  
  <p>I will be using a MySql database.</p>
  
  <p>This is just a small example of my problem and have forms with 50+ fields that all need to interchange like this one but are textboxes, checkboxes, radio buttons, and select drop-downs.</p>
  
  <p>Thank You so much for reading and any advice that is given and I apologize for the length. I wanted to be clear on the issue I am trying to solve.</p>