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

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

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));

报错是说数据库中没有创建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));

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 PRIMARY KEY, 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);
CREATE TABLE VIDEO(VID_NUM int PRIMARY KEY, 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)
);

您好，我是有问必答小助手，您的问题已经有小伙伴帮您解答，感谢您对有问必答的支持与关注！
PS：问答VIP年卡 【限时加赠：IT技术图书免费领】，了解详情>>> https://vip.csdn.net/askvip?utm_source=1146287632