Помогите разобраться в чем дело. Пытаюсь разобраться в чужой базе. Не могу заполнить одну таблицу(route_has_station_has_seat ). Мешает ограничение внешнего ключа, в других таблицах ограничения тоже есть. Все айдишники ставил на своих местах.


INSERT INTO country (idcountry, country)
VALUES (1,"Барановичи");

INSERT INTO station (idstation,name,city,country_idcountry)
VALUES (6,"Минск","Минск",1);

INSERT INTO train(idtrain,number)
VALUES (1,"409Д");

INSERT INTO wagon(idwagon,number,type,train_idtrain)
VALUES (7,7,6,1);/*типы вагонов от 1 до 6*/

INSERT INTO seat (number,wagon_idwagon)
VALUES (1,1);

INSERT INTO route(idroute)
VALUES (1);

INSERT INTO driver (iddriver,name,surname,birth_date,phone_number)
VALUES (1,"Сергей","Алексеев","1970.02.01","+375297652305");

INSERT INTO route_has_train (route_idroute,train_idtrain,driver_iddriver)
VALUES (1,1,1);

INSERT INTO route_has_station (route_idroute,station_idstation,arriveTime,departTime,numberStation)
VALUES (1,2,"2015-01-15 12:10:00","2015-01-15 15:10:00",20);

INSERT INTO user (iduser,station_idstation,login,password,name,surname)
VALUES (2,1,'user','user','Андрей','Скворцов');

INSERT INTO ticket (idticket,firststation,laststation,user_iduser,time,cost)
VALUES (2,6,2,1,now(),17500);

INSERT INTO route_has_station_has_seat (route_has_station_route_idroute,route_has_station_station_idstation,route_has_station_numberStation,seat_wagon_idwagon,seat_number,cost,access,ticket_idticket)
VALUES (1,6,20,1,5,17500,1,2);

INSERT INTO country (idcountry, country)
VALUES (1,"Барановичи");

INSERT INTO station (idstation,name,city,country_idcountry)
VALUES (6,"Минск","Минск",1);

INSERT INTO train(idtrain,number)
VALUES (1,"409Д");

INSERT INTO wagon(idwagon,number,type,train_idtrain)
VALUES (7,7,6,1);/*типы вагонов от 1 до 6*/

INSERT INTO seat (number,wagon_idwagon)
VALUES (1,1);

INSERT INTO route(idroute)
VALUES (1);

INSERT INTO driver (iddriver,name,surname,birth_date,phone_number)
VALUES (1,"Сергей","Алексеев","1970.02.01","+375297652305");

INSERT INTO route_has_train (route_idroute,train_idtrain,driver_iddriver)
VALUES (1,1,1);

INSERT INTO route_has_station (route_idroute,station_idstation,arriveTime,departTime,numberStation)
VALUES (1,2,"2015-01-15 12:10:00","2015-01-15 15:10:00",20);

INSERT INTO user (iduser,station_idstation,login,password,name,surname)
VALUES (2,1,'user','user','Андрей','Скворцов');

INSERT INTO ticket (idticket,firststation,laststation,user_iduser,time,cost)
VALUES (2,6,2,1,now(),17500);
/*Здесь ошибка*/
INSERT INTO route_has_station_has_seat (route_has_station_route_idroute,route_has_station_station_idstation,route_has_station_numberStation,seat_wagon_idwagon,seat_number,cost,access,ticket_idticket)
VALUES (1,6,20,1,5,17500,1,2);

Код самой базы

-- MySQL Script generated by MySQL Workbench
-- 12/13/14 16:18:30
-- Model: New Model Version: 1.0
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';

-- -----------------------------------------------------
-- Schema CourseProgect_db
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `CourseProgect_db` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
USE `CourseProgect_db` ;

-- -----------------------------------------------------
-- Table `CourseProgect_db`.`train`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `CourseProgect_db`.`train` (
`idtrain` INT NOT NULL AUTO_INCREMENT,
`number` VARCHAR(25) NULL,
PRIMARY KEY (`idtrain`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `CourseProgect_db`.`country`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `CourseProgect_db`.`country` (
`idcountry` INT NOT NULL,
`country` VARCHAR(45) NOT NULL,
PRIMARY KEY (`idcountry`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `CourseProgect_db`.`station`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `CourseProgect_db`.`station` (
`idstation` INT NOT NULL AUTO_INCREMENT,
`name` VARCHAR(45) NULL,
`city` VARCHAR(45) NULL,
`country_idcountry` INT NOT NULL,
PRIMARY KEY (`idstation`),
INDEX `name_idx` (`name` ASC),
INDEX `city_idx` (`city` ASC),
UNIQUE INDEX `name_UNIQUE` (`name` ASC),
INDEX `fk_station_country1_idx` (`country_idcountry` ASC),
CONSTRAINT `fk_station_country1`
FOREIGN KEY (`country_idcountry`)
REFERENCES `CourseProgect_db`.`country` (`idcountry`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `CourseProgect_db`.`route`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `CourseProgect_db`.`route` (
`idroute` INT NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`idroute`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `CourseProgect_db`.`wagon`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `CourseProgect_db`.`wagon` (
`idwagon` INT NOT NULL AUTO_INCREMENT,
`number` INT NOT NULL,
`type` ENUM('general','seating','second-class','compartment','sv','soft') NULL,
`train_idtrain` INT NOT NULL,
PRIMARY KEY (`idwagon`),
INDEX `fk_wagon_train1_idx` (`train_idtrain` ASC),
CONSTRAINT `fk_wagon_train1`
FOREIGN KEY (`train_idtrain`)
REFERENCES `CourseProgect_db`.`train` (`idtrain`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `CourseProgect_db`.`route_has_station`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `CourseProgect_db`.`route_has_station` (
`route_idroute` INT NOT NULL,
`station_idstation` INT NOT NULL,
`arriveTime` DATETIME NULL,
`departTime` DATETIME NULL,
`numberStation` INT NOT NULL,
PRIMARY KEY (`route_idroute`, `station_idstation`, `numberStation`),
INDEX `fk_route_has_station_station1_idx` (`station_idstation` ASC),
INDEX `fk_route_has_station_route1_idx` (`route_idroute` ASC),
CONSTRAINT `fk_route_has_station_route1`
FOREIGN KEY (`route_idroute`)
REFERENCES `CourseProgect_db`.`route` (`idroute`)
ON DELETE CASCADE
ON UPDATE CASCADE,
CONSTRAINT `fk_route_has_station_station1`
FOREIGN KEY (`station_idstation`)
REFERENCES `CourseProgect_db`.`station` (`idstation`)
ON DELETE CASCADE
ON UPDATE CASCADE)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `CourseProgect_db`.`driver`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `CourseProgect_db`.`driver` (
`iddriver` INT NOT NULL,
`name` VARCHAR(45) NULL,
`surname` VARCHAR(45) NULL,
`birth_date` DATE NULL,
`phone_number` VARCHAR(15) NULL,
PRIMARY KEY (`iddriver`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `CourseProgect_db`.`route_has_train`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `CourseProgect_db`.`route_has_train` (
`route_idroute` INT NOT NULL,
`train_idtrain` INT NOT NULL,
`driver_iddriver` INT NOT NULL,
PRIMARY KEY (`route_idroute`, `train_idtrain`),
INDEX `fk_route_has_train_train1_idx` (`train_idtrain` ASC),
INDEX `fk_route_has_train_route1_idx` (`route_idroute` ASC),
INDEX `fk_route_has_train_driver1_idx` (`driver_iddriver` ASC),
CONSTRAINT `fk_route_has_train_route1`
FOREIGN KEY (`route_idroute`)
REFERENCES `CourseProgect_db`.`route` (`idroute`)
ON DELETE CASCADE
ON UPDATE CASCADE,
CONSTRAINT `fk_route_has_train_train1`
FOREIGN KEY (`train_idtrain`)
REFERENCES `CourseProgect_db`.`train` (`idtrain`)
ON DELETE CASCADE
ON UPDATE CASCADE,
CONSTRAINT `fk_route_has_train_driver1`
FOREIGN KEY (`driver_iddriver`)
REFERENCES `CourseProgect_db`.`driver` (`iddriver`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `CourseProgect_db`.`seat`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `CourseProgect_db`.`seat` (
`number` INT NOT NULL,
`wagon_idwagon` INT NOT NULL,
PRIMARY KEY (`wagon_idwagon`, `number`),
CONSTRAINT `fk_seat_wagon1`
FOREIGN KEY (`wagon_idwagon`)
REFERENCES `CourseProgect_db`.`wagon` (`idwagon`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `CourseProgect_db`.`user`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `CourseProgect_db`.`user` (
`iduser` INT NOT NULL,
`station_idstation` INT NOT NULL,
`login` VARCHAR(45) NOT NULL,
`password` VARCHAR(45) NOT NULL,
`name` VARCHAR(45) NULL,
`surname` VARCHAR(45) NULL,
PRIMARY KEY (`iduser`),
UNIQUE INDEX `login_UNIQUE` (`login` ASC),
UNIQUE INDEX `password_UNIQUE` (`password` ASC),
INDEX `fk_user_station1_idx` (`station_idstation` ASC),
CONSTRAINT `fk_user_station1`
FOREIGN KEY (`station_idstation`)
REFERENCES `CourseProgect_db`.`station` (`idstation`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `CourseProgect_db`.`ticket`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `CourseProgect_db`.`ticket` (
`idticket` INT NOT NULL AUTO_INCREMENT,
`firststation` INT NOT NULL,
`laststation` INT NOT NULL,
`user_iduser` INT NOT NULL,
`time` DATETIME NULL,
`cost` INT NULL,
PRIMARY KEY (`idticket`),
INDEX `fk_ticket_station1_idx` (`firststation` ASC),
INDEX `fk_ticket_station2_idx` (`laststation` ASC),
INDEX `fk_ticket_user1_idx` (`user_iduser` ASC),
CONSTRAINT `fk_ticket_station1`
FOREIGN KEY (`firststation`)
REFERENCES `CourseProgect_db`.`station` (`idstation`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_ticket_station2`
FOREIGN KEY (`laststation`)
REFERENCES `CourseProgect_db`.`station` (`idstation`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_ticket_user1`
FOREIGN KEY (`user_iduser`)
REFERENCES `CourseProgect_db`.`user` (`iduser`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `CourseProgect_db`.`route_has_station_has_seat`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `CourseProgect_db`.`route_has_station_has_seat` (
`route_has_station_route_idroute` INT NOT NULL,
`route_has_station_station_idstation` INT NOT NULL,
`route_has_station_numberStation` INT NOT NULL,
`seat_wagon_idwagon` INT NOT NULL,
`seat_number` INT NOT NULL,
`cost` INT NULL,
`access` TINYINT(1) NULL,
`ticket_idticket` INT NULL,
PRIMARY KEY (`route_has_station_route_idroute`, `route_has_station_station_idstation`, `route_has_station_numberStation`, `seat_wagon_idwagon`, `seat_number`),
INDEX `fk_route_has_station_has_seat_seat1_idx` (`seat_wagon_idwagon` ASC, `seat_number` ASC),
INDEX `fk_route_has_station_has_seat_route_has_station1_idx` (`route_has_station_route_idroute` ASC, `route_has_station_station_idstation` ASC, `route_has_station_numberStation` ASC),
INDEX `fk_route_has_station_has_seat_ticket1_idx` (`ticket_idticket` ASC),
CONSTRAINT `fk_route_has_station_has_seat_route_has_station1`
FOREIGN KEY (`route_has_station_route_idroute` , `route_has_station_station_idstation` , `route_has_station_numberStation`)
REFERENCES `CourseProgect_db`.`route_has_station` (`route_idroute` , `station_idstation` , `numberStation`)
ON DELETE CASCADE
ON UPDATE CASCADE,
CONSTRAINT `fk_route_has_station_has_seat_seat1`
FOREIGN KEY (`seat_wagon_idwagon` , `seat_number`)
REFERENCES `CourseProgect_db`.`seat` (`wagon_idwagon` , `number`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk_route_has_station_has_seat_ticket1`
FOREIGN KEY (`ticket_idticket`)
REFERENCES `CourseProgect_db`.`ticket` (`idticket`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

спасибо