CREATE TABLE SERIES(
   seriesId INT AUTO_INCREMENT,
   seriesTitle VARCHAR(50)  NOT NULL,
   releaseYear YEAR NOT NULL,
   seriesImage VARCHAR(50)  NOT NULL,
   alsoKnownAs VARCHAR(50) ,
   PRIMARY KEY(seriesId),
   UNIQUE(seriesImage)
);

CREATE TABLE SEASON(
   seasonId INT AUTO_INCREMENT,
   seasonNumber TINYINT NOT NULL,
   PRIMARY KEY(seasonId),
   UNIQUE(seasonNumber)
);

CREATE TABLE EPISODE(
   episodeId INT AUTO_INCREMENT,
   episodeNumber TINYINT NOT NULL,
   seasonEpisodeNumber TINYINT NOT NULL,
   episodeTitle VARCHAR(50)  NOT NULL,
   seriesId INT NOT NULL,
   seasonId INT NOT NULL,
   PRIMARY KEY(episodeId),
   FOREIGN KEY(seriesId) REFERENCES SERIES(seriesId),
   FOREIGN KEY(seasonId) REFERENCES SEASON(seasonId)
);

CREATE TABLE FRENCH_EPISODE(
   episodeId INT,
   PRIMARY KEY(episodeId),
   FOREIGN KEY(episodeId) REFERENCES EPISODE(episodeId)
);

CREATE TABLE FOREIGN_EPISODE(
   episodeId INT,
   frenchEpisodeTitle VARCHAR(50)  NOT NULL,
   PRIMARY KEY(episodeId),
   FOREIGN KEY(episodeId) REFERENCES EPISODE(episodeId)
);