Re: Foreign Key for multi PK or design question

Поиск
Список
Период
Сортировка
От PostgreSQL Admin
Тема Re: Foreign Key for multi PK or design question
Дата
Msg-id 475EE126.5030302@productivitymedia.com
обсуждение исходный текст
Ответ на Re: Foreign Key for multi PK or design question  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Ответы Re: Foreign Key for multi PK or design question
Re: Foreign Key for multi PK or design question
Список pgsql-sql
This is my layout so far:

CREATE TABLE users (
id serial NOT NULL,
--question REFERENCES questions(id) ON DELETE CASCADE ## ON REMOVED##
);

CREATE TABLE questions (
id serial NOT NULL,
questions varchar(450) NOT NULL
);

CREATE TABLE answers (
id serial NOT NULL,
question_id int REFERENCES questions(id) ON DELETE CASCADE,
user_id int REFERENCES users(id) ON DELETE CASCADE,
answer varchar(450) NOT NULL,
created timestamptz NOT NULL
);

Originally I wanted to have a foreign key that would be the pk of the
question table.  So if the user answered Q2, 5 and 6 - the user.fk would
store values 2,5,6 - but I have passed most of logic to the answer table.

Does this look correct? or most efficient?

J


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

Предыдущее
От: "A. Kretschmer"
Дата:
Сообщение: Re: Foreign Key for multi PK or design question
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Foreign Key for multi PK or design question