[sql] 123
Viewer
- CREATE DATABASE cinema;
- USE cinema;
- CREATE TABLE movies (
- movie_id INT PRIMARY KEY,
- title VARCHAR(255) NOT NULL,
- release_year YEAR(4) NOT NULL,
- genre VARCHAR(255) NOT NULL,
- director VARCHAR(255) NOT NULL,
- runtime INT NOT NULL
- );
- CREATE TABLE showtimes (
- showtime_id INT PRIMARY KEY,
- movie_id INT NOT NULL,
- start_time DATETIME NOT NULL,
- theater_number INT NOT NULL,
- FOREIGN KEY (movie_id) REFERENCES movies(movie_id)
- );
- CREATE TABLE seats (
- seat_id INT PRIMARY KEY,
- theater_number INT NOT NULL,
- ROW_NUMBER INT NOT NULL,
- seat_number INT NOT NULL
- );
- CREATE TABLE customers (
- customer_id INT PRIMARY KEY,
- first_name VARCHAR(255) NOT NULL,
- last_name VARCHAR(255) NOT NULL,
- email VARCHAR(255) NOT NULL,
- phone_number VARCHAR(20) NOT NULL,
- address VARCHAR(255) NOT NULL
- );
- CREATE TABLE reservations (
- reservation_id INT PRIMARY KEY,
- showtime_id INT NOT NULL,
- customer_id INT NOT NULL,
- seat_id INT NOT NULL,
- FOREIGN KEY (showtime_id) REFERENCES showtimes(showtime_id),
- FOREIGN KEY (customer_id) REFERENCES customers(customer_id),
- FOREIGN KEY (seat_id) REFERENCES seats(seat_id)
- );
Editor
You can edit this paste and save as new:
File Description
- 123
- Paste Code
- 20 Mar-2023
- 1.15 Kb
You can Share it:
Latest Code Pastes