Database Design for API
How would you guys go about designing a table/api for something like a form builder for a specific purpose.
For example I want the users to be able to add inputs etc, and right now I just save these as json in a json column for each form type created by a user, however when it comes to types, this isn't so convenient. So I was thinking of possibly just making the form inputs to be stored as a list of json, where each input would have { name:"", Value:"", Type:"", Validation:"" } and then just parsing the json array into a form and to store it's values. Almost like EAV style, but per a row since we have json columns now
For example I want the users to be able to add inputs etc, and right now I just save these as json in a json column for each form type created by a user, however when it comes to types, this isn't so convenient. So I was thinking of possibly just making the form inputs to be stored as a list of json, where each input would have { name:"", Value:"", Type:"", Validation:"" } and then just parsing the json array into a form and to store it's values. Almost like EAV style, but per a row since we have json columns now
Similar Threads
Was this page helpful?
