[sql] booking
Viewer
- /*
- SQL for creating the cinema online booking system
- */
- CREATE DATABASE cinema_booking_system;
- USE cinema_booking_system;
- CREATE TABLE films (
- id INT PRIMARY KEY AUTO_INCREMENT,
- name VARCHAR(45) NOT NULL UNIQUE,
- length_min INT NOT NULL
- );
- CREATE TABLE customers (
- id INT PRIMARY KEY AUTO_INCREMENT,
- first_name VARCHAR(45),
- last_name VARCHAR(45) NOT NULL,
- email VARCHAR(45) NOT NULL UNIQUE
- );
- CREATE TABLE rooms (
- id INT PRIMARY KEY AUTO_INCREMENT,
- name VARCHAR(45) NOT NULL,
- no_seats INT NOT NULL
- );
- CREATE TABLE screenings (
- id INT PRIMARY KEY AUTO_INCREMENT,
- film_id INT NOT NULL,
- room_id INT NOT NULL,
- start_time DATETIME NOT NULL,
- FOREIGN KEY (film_id) REFERENCES films(id),
- FOREIGN KEY (room_id) REFERENCES rooms(id)
- );
- CREATE TABLE seats (
- id INT PRIMARY KEY AUTO_INCREMENT,
- ROW CHAR(1) NOT NULL,
- NUMBER INT NOT NULL,
- room_id INT NOT NULL,
- FOREIGN KEY (room_id) REFERENCES rooms(id)
- );
- CREATE TABLE bookings (
- id INT PRIMARY KEY AUTO_INCREMENT,
- screening_id INT NOT NULL,
- customer_id INT NOT NULL,
- FOREIGN KEY (screening_id) REFERENCES screenings(id),
- FOREIGN KEY (customer_id) REFERENCES customers(id)
- );
- CREATE TABLE reserved_seat (
- id INT PRIMARY KEY AUTO_INCREMENT,
- booking_id INT NOT NULL,
- seat_id INT NOT NULL,
- FOREIGN KEY (booking_id) REFERENCES bookings(id),
- FOREIGN KEY (seat_id) REFERENCES seats(id)
- );
Editor
You can edit this paste and save as new:
File Description
- booking
- Paste Code
- 20 Jan-2022
- 1.4 Kb
You can Share it:
Latest Code Pastes