Table: movie_genres

SHOW CREATE TABLE movie_genres

CREATE TABLE `movie_genres` (
  `movieId` int(11) NOT NULL,
  `genre` varchar(50) NOT NULL,
  PRIMARY KEY (`movieId`,`genre`),
  CONSTRAINT `movie_genres_ibfk_1` FOREIGN KEY (`movieId`) REFERENCES `movies` (`movieId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci `ENCRYPTION_KEY_ID`=100

SELECT * FROM movie_genres