 	PRIMARY KEY (theater_id)
 );
 
-CREATE TABLE show (
+CREATE TABLE shows (
 	show_id INT AUTO_INCREMENT,
 	movie_id INT,
-	theater_id INT
+	theater_id INT,
 	start_time TIMESTAMP,
 	end_time TIMESTAMP,
 	subtitle VARCHAR(30),


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

CREATE TABLE act (

	seat_no VARCHAR(5),

	PRIMARY KEY (ticket_id),
	FOREIGN KEY (show_id) REFERENCES shows(show_id),
	FOREIGN KEY (customer_id) REFERENCES customer(customer_id)
);
