create table film_screenings (
id serial primary key,
film int references films(id), -- фильм
hall int references halls(id), -- кинозал
screening_time tzrange, -- дата и время начала сеанса
recomended_price numeric, -- рекомендованная цена билета
constraint no_screening_time_overlap exclude using gist (
screening_time WITH && -- check for overlapping ranges
)
);