 	seat_no VARCHAR(5),
 
 	PRIMARY KEY (ticket_id),
-	FOREIGN KEY (show_id) REFERENCES show(show_id),
+	FOREIGN KEY (show_id) REFERENCES shows(show_id),
 	FOREIGN KEY (customer_id) REFERENCES customer(customer_id)
 );


	FOREIGN KEY (movie_id) REFERENCES movie(movie_id),
	FOREIGN KEY (director_id) REFERENCES director(director_id)
);

CREATE TABLE act (

	PRIMARY KEY (theater_id)
);

CREATE TABLE shows (
	show_id INT AUTO_INCREMENT,
	movie_id INT,
	theater_id INT,
	start_time TIMESTAMP,
	end_time TIMESTAMP,
	subtitle VARCHAR(30),
