---

halls (
    id SERIAL PRIMARY KEY,
    name TEXT,
    capacity INT
)

seats (
    id SERIAL PRIMARY KEY,
    hall_id INT REFERENCES halls(id),
    row INT,
    seat_number INT
)