SQL 错误: ORA-02270: 此列列表的唯一关键字或主键不匹配
收藏表,报错,怎么解决??
建表如下:
外表(1):
--文件表
CREATE TABLE files(
id varchar2(32) default SYS_GUID(),
fileNum VARCHAR2(50) NOT NULL,
fileName VARCHAR2(50),
oldfileName VARCHAR2(50),
uploadTime timestamp,
username VARCHAR2(50),
userId VARCHAR2(50),
url VARCHAR2(50),
label VARCHAR2(50),
fileDesc VARCHAR2(500),
format VARCHAR2(50),
classify INT,
integral INT,
fileStatus INT,
file_md VARCHAR2(50),
PRIMARY KEY(id,userId),
CONSTRAINT files UNIQUE (id,fileNum),
FOREIGN KEY (userId) REFERENCES users(id)
)
外表(2)
--课程表
CREATE TABLE courses(
id varchar2(32) default SYS_GUID() PRIMARY KEY,
coursesNum VARCHAR2(50) NOT NULL,
coursesName VARCHAR2(50),
oldfileName VARCHAR2(50),
uploadTime timestamp,
username VARCHAR2(50),
userId VARCHAR2(50),
url VARCHAR2(50),
label VARCHAR2(50),
coursesDesc VARCHAR2(500),
format VARCHAR2(50),
classify INT,
integral INT,
coursesStatus INT,
file_md VARCHAR2(50),
PRIMARY KEY(id,userId),
CONSTRAINT courses UNIQUE (id,coursesNum),
FOREIGN KEY (userId) REFERENCES users(id)
)
外表(3)
-- 用户表
CREATE TABLE users(
id varchar2(32) default SYS_GUID() PRIMARY KEY,
email VARCHAR2(50) UNIQUE NOT NULL,
username VARCHAR2(50),
PASSWORD VARCHAR2(50),
phoneNum VARCHAR2(20),
STATUS INT
)
主表:
-- 收藏表:
CREATE TABLE favorite(
id varchar2(32) default SYS_GUID(),
userId varchar2(32),
fileId varchar2(32),
coursesId varchar2(32),
downloadTime TIMESTAMP,
PRIMARY KEY(id,userId,fileId,coursesId),
FOREIGN KEY (userId) REFERENCES users(id),
FOREIGN KEY (fileId) REFERENCES files(id),
FOREIGN KEY (coursesId) REFERENCES courses(id)
)