Which is the best way to create a relationship between two tables when referenced table has a composite primary key?
x
table1{
id,
name
}
table2{
id1,
id2,
name
}PrimaryKey(id1, id2)
Advertisement
Answer
One way is this
alter table t add constraint fk_t_id1_id2
foreign key (id1, id2) references table2(id1, id2);
As Gordon said, the best option is create an auto incremental ID and make this the primary key.