Неправильная работа внешнего ключа

CREATE TABLE м (
 
model CHAR(50) NOT NULL,
reg_number INT NOT NULL,
color CHAR(15) NOT NULL,
id INT NOT NULL,
PRIMARY KEY(id)
)
 
CREATE TABLE t(
use_on DATE DEFAULT NULL,
car_number INT,
driver_number SMALLINT,
id INT NOT NULL,
PRIMARY KEY(id),
 
)
INSERT INTO t ( id,use_on, driver_number) 
VALUES ('6','01.10.1992',  '1021'),
('7','01.10.1992',  '1022'),
('8','01.10.1992',  '1020')
 
INSERT INTO м ( id, model, reg_number, color) 
VALUES ('6','ваз1', '452', 'красный'),
('8','ваз2', '453', 'черный'),
('7','ваз3', '454', 'черный')
SELECT *FROM м
SELECT *FROM t

CREATE TABLE f (
 
model CHAR(50) NOT NULL,
reg_number INT NOT NULL,
color CHAR(15) NOT NULL,
id INT NOT NULL,
PRIMARY KEY(id)
)
 
CREATE TABLE tt(
use_on DATE DEFAULT NULL,
car_number INT,
driver_number SMALLINT,
id INT NOT NULL,
PRIMARY KEY(id),
FOREIGN KEY (car_number) REFERENCES f (id)
 
)
INSERT INTO tt ( id,use_on, driver_number) 
VALUES ('9','01.10.1992',  '1021'),
('11','01.10.1992',  '1022'),
('10','01.10.1992',  '1020')
 
INSERT INTO f ( id, model, reg_number, color) 
VALUES ('6','ваз1', '452', 'красный'),
('8','ваз2', '453', 'черный'),
('7','ваз3', '454', 'черный')