Re: Stroring html form settings

Поиск
Список
Период
Сортировка
От Dianne Yumul
Тема Re: Stroring html form settings
Дата
Msg-id CD91E87E-4E5D-4F56-8A96-FE0A15E437A5@wellsgaming.com
обсуждение исходный текст
Ответ на Re: Stroring html form settings  (Reece Hart <reece@harts.net>)
Список pgsql-general
Would an EAV model work? I'm thinking something like <form,field,value>. For example:
formA,ckbox1,true
formA,input1,initial value
formB,textarea1,enter your long comment here

You could easily extend this to <user,form,field,value>, or normalize it as you see fit.

This would work great too. If we go this route, we'll keep it simple and use the <user_id, report_id, field, value>, as you suggested, where user_id and report_id are foreign key references.

Another possibility is to use hstore hashes for form fields/values. See
http://www.postgresql.org/docs/8.3/static/hstore.html

I will look into this too. But we'll have to upgrade to 8.3 which is not a problem.

Thank you Reece.

Dianne

В списке pgsql-general по дате отправления:

Предыдущее
От: Reece Hart
Дата:
Сообщение: Re: Stroring html form settings
Следующее
От: Bill Thoen
Дата:
Сообщение: Need Some Explanation of an EXPLAIN