CREATE TABLE CinemaHall (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    rows INT,
    seats_per_row INT
);

CREATE TABLE Seat (
    id INT PRIMARY KEY,
    hall_id INT REFERENCES CinemaHall(id),
    row_number INT,
    seat_number INT,
    type VARCHAR(20)
);

CREATE TABLE Movie (
    id INT PRIMARY KEY,
    title VARCHAR(255),
    duration INT, -- в минутах
    rating VARCHAR(10),
    description TEXT
);

CREATE TABLE Screening (
    id INT PRIMARY KEY,
    movie_id INT REFERENCES Movie(id),
    hall_id INT REFERENCES CinemaHall(id),
    start_time TIMESTAMP,
    price DECIMAL(10,2)
);

CREATE TABLE Ticket (
    id INT PRIMARY KEY,
    screening_id INT REFERENCES Screening(id),
    seat_id INT REFERENCES Seat(id),
    status VARCHAR(20),
    user_id INT
);