create table Researcher
(Pid number(7),lname varchar2(12),fname char(10),constraint pkResearcher PRIMARY KEY(Pid));
create table Project
(ProjId char(10),MedicName varchar2(10),Purpose varchar2(12),Start_date date,End_date date,PI_Id number (7),constraint pkProject PRIMARY KEY(ProjId),constraint fkProject FOREIGN KEY (PI_Id) references Researcher);
我最近开始学习sql。
我之前插入了一条语句:
insert into Project
values ('PR001','Medic1','heart','1-SEP-2017','31-JUL-2019','10001');
此语句已创建,但是当我尝试下一条语句时:
insert into Project
values ('PR005','Medic5','blood','10-JUL-18','31-JAN-20','10102');
我遇到违反错误完整性约束(FKPROJECT)的问题-找不到父键