theatre_id doesn't exist in this table.

CREATE TABLE `eeu23e`.`stage_show` (
	`stage_show_id`			INT AUTO_INCREMENT NOT NULL,
    `name`					VARCHAR(255) NOT NULL,
    `theatre`				INT NOT NULL,
    `date_opened`			DATE NOT NULL,
    `date_closed`			DATE,
    `average_rating`		DECIMAL(3,1),
    PRIMARY KEY (`stage_show_id`),
    INDEX `uq_stage_show_name`(`name` ASC),
    CONSTRAINT `uq_stage_show`
		UNIQUE KEY(`name`),
	INDEX `fk_stage_show_theatre_idx`(`theatre_id` ASC),
    CONSTRAINT `fk_theatre`
		FOREIGN KEY(`theatre_id`)
        REFERENCES `eeu23e`.`theatre`(`theatre_id`)
) ENGINE = InnoDB;