问题遇到的现象和发生背景
问题相关代码,请勿粘贴截图
运行结果及报错内容
我的解答思路和尝试过的方法
我想要达到的结果
CREATE TABLE tb_JobInfo
(JobID INT ,
JobName VARCHAR(30) PRIMARY KEY,
Remark VARCHAR(300),
);
CREATE TABLE tb_DepartInfo
(DID INT PRIMARY KEY ,
Dname VARCHAR(30),
Dleader VARCHAR(30),
Remark VARCHAR(300),
);
CREATE TABLE tb_PersonInfo
(PID VARCHAR(30) ,
Pname VARCHAR(30),
DID INT ,
JobName VARCHAR(30),
Psex CHAR(30),
Pplace VARCHAR(30),
Plevel VARCHAR(30),
Pspecial VARCHAR(30),
Pbusi VARCHAR(30),
Remark VARCHAR(300),
LoginDate DATETIME,
PRIMARY KEY(PID,DID,JobName),
FOREIGN KEY (DID) REFERENCES tb_DepartInfo (DID),
FOREIGN KEY (JobName) REFERENCES tb_JobInfo (JobName),
);
CREATE TABLE tb_Income
(IID INT ,
Imonth VARCHAR(30),
PID VARCHAR(30) PRIMARY KEY,
Icome VARCHAR(30),
Remark VARCHAR(300),
LoginDate DATETIME,
FOREIGN KEY (PID) REFERENCES tb_PersonInfo(PID),
);
这是最终想要得到参照关系,错误是 FOREIGN KEY (PID) REFERENCES tb_PersonInfo(PID),这一句报错引用了无效的表,我在网上查了好久应该是参照关系出错了,但是不知道怎么改