我正在学习如何为具有主键和外键约束的班级创建一个小型且简单的数据库。尝试运行我的ALTER TABLE语句时,我得到ORA-02770,据我所知,该语句通知我在外部表中引用的列未作为主键约束列出。但是,从我看到的语法来看,在CREATE TABLES语句中命名主键是正确的。我在all_cons_columns表中搜索player_info表,它还显示了列出的主键。我可以得到一些指导吗?下面列出的是我当前的脚本:
CREATE TABLE Player_Game
( school varchar2(30),player_number number(2,0),game_number number(1,CONSTRAINT playergame_pk PRIMARY KEY (school,player_number,game_number)
);
CREATE TABLE School
( school varchar2(30),city varchar2(30),coach varchar2(30),team_name varchar2(30),win_record number (2,loss_record number (2,CONSTRAINT school_pk PRIMARY KEY (school)
);
CREATE TABLE Game
( school varchar2(30),game_date DATE,game_score varchar2(15),CONSTRAINT game_pk PRIMARY KEY (school,game_number)
);
CREATE TABLE player_info
( school varchar2(30),player_name varchar2(25),CONSTRAINT playerinfo_pk PRIMARY KEY (school,player_number)
);
CREATE TABLE city
( city varchar2(30),population number(5,CONSTRAINT city_pk PRIMARY KEY (city)
);
/*Here is the failing alter command */
ALTER TABLE Player_Game
ADD CONSTRAINT playergame_fk FOREIGN KEY (school) REFERENCES game(school);