创建表格和声明主外键时代码出现问题怎么改怎么改

Question

创建表格和声明主键外键时出现问题，下面代码怎么改？

CREATE SCHEMA Task3;
use Task3;
CREATE TABLE MEMBERSHIP(MEM_NUM int PRIMARY KEY, MEM_FNAME CHAR(21), MEM_LNAME CHAR(21), MEM_STREET CHAR(30), MEM_CITY CHAR(24), MEM_STATE CHAR(10), MEM_ZIP CHAR(15), MEM_BALANCE CHAR(18));
CREATE TABLE RENTAL(RENT_NUM int, RENT_DATE CHAR(35), MEM_NUM int, FOREIGN KEY (MEM_NUM) REFERENCES MEMBERSHIP(MEM_NUM));
CREATE TABLE PRICE(PRICE_CODE int, PRICE_DESCRIPTION CHAR(20), PRICE_RENTFEE CHAR(15), PRICE_DAILYLATEFEE CHAR(8));
CREATE TABLE MOVIE(MOVIE_NUM int, MOVIE_TITLE CHAR(50), MOVIE_YEAR int, MOVIE_COST CHAR(10), MOVIE_GENRE CHAR(20), PRICE_CODE int, FOREIGN KEY(PRICE_CODE) REFERENCES PRICE(PRICE_CODE));
CREATE TABLE VIDEO(VID_NUM int, VID_INDATE CHAR(20), MOVIE_NUM int, FOREIGN KEY (MOVIE_NUM) REFERENCES MOVIE(MOVIE_NUM));
CREATE TABLE DETAILRENTAL(RENT_NUM int, VID_NUM int, DETAIL_FEE CHAR(9), DETAIL_DUEDATE CHAR(18), DETAIL_RETURNDATE CHAR(20), DETAIL_DAILYLATEFEE CHAR(8), CONSTRAINT DETAIL_RENT_VID_PK PRIMARY KEY (RENT_NUM, VID_NUM));

Answer 1

报错是说数据库中没有创建xx数据表。
需要注意，外键字段需要是唯一的，不能出现字段值重复的情况，所以给外键加上unique或者设置为主键

CREATE TABLE MEMBERSHIP(MEM_NUM int PRIMARY KEY, MEM_FNAME CHAR(21), MEM_LNAME CHAR(21), MEM_STREET CHAR(30), MEM_CITY CHAR(24), MEM_STATE CHAR(10), MEM_ZIP CHAR(15), MEM_BALANCE CHAR(18));
CREATE TABLE RENTAL(RENT_NUM int, RENT_DATE CHAR(35), MEM_NUM int, FOREIGN KEY (MEM_NUM) REFERENCES MEMBERSHIP(MEM_NUM));
CREATE TABLE PRICE(PRICE_CODE int PRIMARY KEY, PRICE_DESCRIPTION CHAR(20), PRICE_RENTFEE CHAR(15), PRICE_DAILYLATEFEE CHAR(8));
CREATE TABLE MOVIE(MOVIE_NUM int PRIMARY KEY, MOVIE_TITLE CHAR(50), MOVIE_YEAR int, MOVIE_COST CHAR(10), MOVIE_GENRE CHAR(20), PRICE_CODE int, FOREIGN KEY(PRICE_CODE) REFERENCES PRICE(PRICE_CODE));
CREATE TABLE VIDEO(VID_NUM int, VID_INDATE CHAR(20), MOVIE_NUM int, FOREIGN KEY (MOVIE_NUM) REFERENCES MOVIE(MOVIE_NUM));
CREATE TABLE DETAILRENTAL(RENT_NUM int, VID_NUM int, DETAIL_FEE CHAR(9), DETAIL_DUEDATE CHAR(18), DETAIL_RETURNDATE CHAR(20), DETAIL_DAILYLATEFEE CHAR(8), CONSTRAINT DETAIL_RENT_VID_PK PRIMARY KEY (RENT_NUM, VID_NUM));