Displaying 1 result from an estimated 1 matches for "fk_qid".
Did you mean:
fk_aid
2006 Jan 04
4
many to many link table compound primary key explosion
...h_unique_answer method to the questions model and check for existing
links there first? Or override the @question.answers method?
Thanks in advance,
John.
http://johnleach.co.uk
create table answers_questions (
question_id int unsigned not null,
answer_id int unsigned not null,
constraint fk_qid foreign key (question_id) references questions(id),
constraint fk_aid foreign key (answer_id) references answers(id),
primary key (question_id, answer_id)
) ENGINE=InnoDB;