From: | Andreas <maps(dot)on(at)gmx(dot)net> |
---|---|
To: | PostgresSQL list <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Re: constants in 2-column foreign keys or how to design a storage for text-groups ? |
Date: | 2009-12-11 10:20:47 |
Message-ID: | 4B221CFF.4060200@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Jasen Betts schrieb:
> On 2009-12-09, Andreas <maps(dot)on(at)gmx(dot)net> wrote:
> ...
>
>> stupid example:
>> ---------------
>> color: red, green, blue
>> size: tiny, little, big, giant
>> structure: hard, soft, floppy
>> How would I solve the rather common text storage issue?
>>
>
> have you considered using enumerated types instead?
Yes, but I need those texts in the GUI to show them as listboxes or
comboboxes.
There might be changes too when I later need to add or drop an option of
a group.
E.g. there are questionnaires to model.
Lets say 10 questions where each has a couple of predefined answers
where one should be selected.
So I've got to store every group of possible answers to a question
either in a seperate table or in a kind of repository all within one big
table (row_id, questionnare_id, question_id, answer_nr, answer)
The row_id so I just need to store 1 value per answer.
Now I've got to make sure that it is impossible that accidentally there
gets a question-17 answer connected to a question-42 and above all, that
the questions dont get mixed between the questionnaires.
I can do this with the frontend and enough hope that nothing bad will
happen.
Still I'd rather hardwire the integrity into the table design.
From | Date | Subject | |
---|---|---|---|
Next Message | Harald Fuchs | 2009-12-11 15:40:13 | Re: Window function trouble |
Previous Message | Pavel Stehule | 2009-12-11 08:48:33 | Re: FIND_IN_SET |