数据库表字段是活的设计

需求：表中字段不固定

方法一：把数据放在一张表中，需要两个表，一个作为模板表i，一个作为数据表 

1.数据库设计

id：主键id

content_key：内容的键

content_value：内容的键的值

template_id：项目id

 模板数据样式

模板真实数据

 

1    姓名    {“id”:"t1","type":"text","alt":"单行文字","label":"姓名",”defVal“:"","required":"true","isActive":"true","placeholder":"内容必填"}    111
2    年龄    {“id”:"t2","type":"text","alt":"单行文字","label":"年龄",”defVal“:"","required":"true","isActive":"true","placeholder":"内容必填"}    111
3    身高    {“id”:"t1","type":"text","alt":"单行文字","label":"身高",”defVal“:"","required":"true","isActive":"true","placeholder":"内容必填"}    112