Quick Links

Foreign Key for multi PK or design question

From:	PostgreSQL Admin <postgres(at)productivitymedia(dot)com>
To:	pgsql-sql(at)postgresql(dot)org
Subject:	Foreign Key for multi PK or design question
Date:	2007-12-11 18:20:52
Message-ID:	475ED504.7080006@productivitymedia.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-sql

I have a table in which people will have a number of questions to
answer. I want those pk to be placed in my user table. So if a user
answers three question I want those 3 pk's in the user table (fk).
What should I be doing?

Thanks in advance,
J

In response to

case sensitivity for tables, columns, and constraint names at 2007-12-11 17:05:25 from Ertel, Steve

Responses

Re: Foreign Key for multi PK or design question at 2007-12-11 18:35:22 from Erik Jones
Re: Foreign Key for multi PK or design question at 2007-12-11 18:53:30 from A. Kretschmer

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Erik Jones	2007-12-11 18:35:22	Re: Foreign Key for multi PK or design question
Previous Message	Gerry Reno	2007-12-11 18:18:17	Re: join on three tables is slow