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 по дате отправления: