สอบถามเรื่องเกี่ยวกับforeign keyที่เชื่อมโยงกับmulti table หน่อยครับ

CREATE TABLE `redetailTB` (
`id_reserve` int(4) NOT NULL,
`id_room` int(3) NOT NULL,
`checkin` int(4) NOT NULL,
`checkout` int(4) NOT NULL,
PRIMARY KEY (`id_reserve`, `id_room`, `checkin`, `checkout`),
FOREIGN KEY (`id_reserve`) REFERENCES reserveTB (`id_reserve`) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (`id_room`) REFERENCES reroomTB (`id_room`) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (`checkin`) REFERENCES inoutTB (`checkin`) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (`checkout`) REFERENCES reserveTB (`checkout`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB;