以下是我的SQL语句：

CREATE DATABASE FOODAPPS;

USE FOODAPPS;

CREATE TABLE Customer (
C_ID        INT             NOT NULL UNIQUE,
C_NAME      VARCHAR(35)     NOT NULL,
C_CON       VARCHAR(20)     NOT NULL,
C_BAL       FLOAT(8,2)      NOT NULL,
PRIMARY KEY(C_ID)
)
ENGINE = INNODB;

CREATE TABLE Restaurant (
R_ID        INT             NOT NULL UNIQUE,
R_ADD       VARCHAR(90)     NOT NULL,
R_CON       VARCHAR(20)     NOT NULL,
R_RATE      DECIMAL(2,1)    NOT NULL,
PRIMARY KEY(R_ID)
)
ENGINE = INNODB;

CREATE TABLE Purchase (
P_ID        INT             NOT NULL UNIQUE,
C_ID        INT,
P_DATE      DATE            NOT NULL,
P_TIME      TIME            NOT NULL,
R_ID        INT,
P_TOTAL     DECIMAL(10,2)   NOT NULL,
PRIMARY KEY(P_ID),
FOREIGN KEY(C_ID)REFERENCES Customer(C_ID),
FOREIGN KEY(R_ID)REFERENCES Restaurant(R_ID)
)
ENGINE = INNODB;

INSERT INTO Customer VALUES('101', 'Devi', '010-8023456', '200.00');
INSERT INTO Customer VALUES('102', 'Jayden', '017-8901234', '650.50');
INSERT INTO Customer VALUES('103', 'Stephanie', '018-9013765', '120.30');
INSERT INTO Customer VALUES('104', 'Michael', '012-3456789', '450.30');
INSERT INTO Customer VALUES('105', 'Abu', '014-2223334', '305.32');

INSERT INTO Restaurant VALUES('201', 'Coconut Street', '088-1234567', '3.5');
INSERT INTO Restaurant VALUES('202', 'Mango Street', '088-2233445', '4.5');
INSERT INTO Restaurant VALUES('203', 'Apple Street', '088-3334445', '4.8');
INSERT INTO Restaurant VALUES('204', 'Peach Street', '088-0110223', '3.7');
INSERT INTO Restaurant VALUES('205', 'Berry Street', '088-8877665', '5.0');

INSERT INTO Purchase VALUES('001', '101', '2024-01-05', '20:08:00', '201', '80.00');
INSERT INTO Purchase VALUES('002', '102', '2024-01-06', '14:08:00', '202', '75.00');
INSERT INTO Purchase VALUES('003', '103', '2024-01-07', '16:05:00', '203', '70.50');
INSERT INTO Purchase VALUES('004', '104', '2024-01-08', '13:25:00', '204', '55.70');
INSERT INTO Purchase VALUES('005', '105', '2024-01-09', '19:05:00', '205', '98.50');

SELECT \* FROM Customer;
SELECT \* FROM Restaurant;
SELECT \* FROM Purchase;

START TRANSACTION;

DELETE FROM Customer WHERE
C_ID = '104';

字符串
我试着运行SQL语句，所有的都很好，直到我试图从客户表中删除一个客户，它指出了一个错误，说#1451 -无法删除或更新父行：外键约束失败（foodapps. purchase，CONSTRAINT purchase_ibfk_1 FOREIGN KEY（C_ID）REFERENCES Customer（C_ID））。