Question

怎么与联合主键建立外键关系

create table voteDetails
(
voteId int foreign key refereneces voteMaster(voteId),
voteDetails int not null,
voteItem varchar(50) not null,
voteSum int not null,
primary key(voteId,voteDetails) --联合主键
)

create table voteLog
(
如何建立与voteDetails表的外键关系？
)
问题已解决，分会给第一个回答的朋友

Answer 1

联合主键建立外键跟简单主键一样的，示例：
mysql> create table tb_key1(id int, itemid int, memo
-> \c
mysql> create table tb_key1(id int, itemid int, memo varchar(20),
-> primary key(id,itemid)
-> );
Query OK, 0 rows affected (0.09 sec)

mysql> create table tb_key2(newid int, itemid int, name varchar(50),
-> foreign key (newid,itemid) references tb_key1(id,itemid)
-> );
Query OK, 0 rows affected (0.08 sec)

mysql> create table tb_key3(myid int,remark varchar(100),
-> foreign key(myid) references tb_key1(id)
-> );
Query OK, 0 rows affected (0.13 sec)

mysql>

Answer 2

create table parent(c1 number,c2 number,
primary key(c1,c2));

create table child (c1 number primary key,
c2 number,c3 number,
foreign key(c2,c3) references parent(c1,c2));