---

CREATE TABLE films (
    film_id INTEGER PRIMARY KEY,
    title TEXT,
    genre TEXT,
    duration INTEGER
);

CREATE TABLE halls (
    hall_id INTEGER PRIMARY KEY,
    hall_name TEXT,
    seats INTEGER
);

CREATE TABLE screenings (
    screening_id INTEGER PRIMARY KEY,
    film_id INTEGER,
    hall_id INTEGER,
    screening_date TEXT,
    screening_time TEXT,
    FOREIGN KEY (film_id) REFERENCES films(film_id),
    FOREIGN KEY (hall_id) REFERENCES halls(hall_id)
);

CREATE TABLE customers (
    customer_id INTEGER PRIMARY KEY,
    full_name TEXT,
    phone TEXT
);

CREATE TABLE bookings (
    booking_id INTEGER PRIMARY KEY,
    customer_id INTEGER,
    screening_id INTEGER,
    seats_booked INTEGER,
    FOREIGN KEY (customer_id) REFERENCES customers(customer_id),
    FOREIGN KEY (screening_id) REFERENCES screenings(screening_id)
);

INSERT INTO films VALUES
(1,'Интерстеллар','Фантастика',169),
(2,'Джон Уик','Боевик',101),
(3,'1+1','Комедия',112);

INSERT INTO halls VALUES
(1,'Зал 1',100),
(2,'Зал 2',80);

INSERT INTO screenings VALUES
(1,1,1,'2025-06-01','18:00'),
(2,2,1,'2025-06-01','21:00'),
(3,3,2,'2025-06-02','17:00'),
(4,1,2,'2025-06-02','20:00');

INSERT INTO customers VALUES
(1,'Иванов Иван','890100001'),
(2,'Петров Петр','890100002'),
(3,'Сидоров Сергей','890100003'),
(4,'Смирнова Анна','890100004');

INSERT INTO bookings VALUES
(1,1,1,2),
(2,2,2,1),
(3,3,3,3),
(4,4,4,2);