minionsDB

CREATE DATABASE `MinionsDB`;
USE `MinionsDB`;

CREATE TABLE `towns` (
    id INT PRIMARY KEY AUTO_INCREMENT,
    town_name VARCHAR(50),
    country_location VARCHAR(50)
);

CREATE TABLE `minions` (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(50),
    age INT,
    town_id INT,
    CONSTRAINT fk_minions_towns FOREIGN KEY (town_id)
        REFERENCES `towns` (id)
);

CREATE TABLE `villains` (
    id INT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(50),
    evilness_factor VARCHAR(6) CHECK (evilness_factor IN ('good' , 'bad', 'evil', 'super evil'))
);

CREATE TABLE `minions_villains` (
    minion_id INT,
    villain_id INT,
    CONSTRAINT pk_mv PRIMARY KEY (minion_id , villain_id),
    CONSTRAINT fk_mv_minions FOREIGN KEY (minion_id)
        REFERENCES `minions` (id),
    CONSTRAINT fk_mv_villains FOREIGN KEY (villain_id)
        REFERENCES `villains` (id)
);