开发者

Table Structure to Store Data from Dynamic Forms

开发者 https://www.devze.com 2023-02-10 16:15 出处:网络
We 开发者_如何学Gohave a Form Builder (web) application which allows users to design their forms dynamically. What could be best table structure to store the data submitted through these dynamically c

We 开发者_如何学Gohave a Form Builder (web) application which allows users to design their forms dynamically. What could be best table structure to store the data submitted through these dynamically created forms?

I am thinking of attribute_name and attribute_value kind of thing? Are there any better alternatives any suggestion to be flexible enough with these two column structure?


I would definitely take a look at Pivot Tables : as you suggest, essentially you have one table which defines the columns contained in a parent object, and another table with an individual row for each attribute value. For dynamic forms, then, as attributes are added, they become rows in a database, not columns. Hope this helps.

0

精彩评论

暂无评论...
验证码 换一张
取 消