eKNgB9xU

1CREATE TABLE IF NOT EXISTS movies
2(
3    id    BIGINT PRIMARY KEY,
4    title VARCHAR(30) UNIQUE NOT NULL
5);
6
7CREATE TABLE IF NOT EXISTS seats
8(
9    id             BIGINT PRIMARY KEY,
10    seat_number    INTEGER                             NOT NULL,
11    reservation_id BIGINT REFERENCES reservations (id) NOT NULL,
12    is_available   BOOLEAN                             NOT NULL,
13    screening_id   BIGINT REFERENCES screenings (id)   NOT NULL
14);
15
16CREATE TABLE IF NOT EXISTS reservations
17(
18    id          BIGINT PRIMARY KEY,
19    username    VARCHAR(30) NOT NULL,
20    surname     VARCHAR(30) NOT NULL,
21    expire_time timestamp   NOT NULL
22);
23
24CREATE TABLE IF NOT EXISTS screenings
25(
26    id             BIGINT PRIMARY KEY,
27    movie_id       BIGINT REFERENCES movies (id)          NOT NULL,
28    screening_time DATE                                   NOT NULL,
29    room_id        BIGINT REFERENCES screening_rooms (id) NOT NULL,
30    ticket_price   NUMERIC(15, 2)                         NOT NULL
31);
32
33CREATE TABLE IF NOT EXISTS screening_rooms
34(
35    id        BIGINT PRIMARY KEY,
36    room_name VARCHAR(30) NOT NULL
37);
38
39CREATE TABLE IF NOT EXISTS rows
40(
41    id                BIGINT PRIMARY KEY,
42    screening_room_id BIGINT REFERENCES screening_rooms (id) NOT NULL
43)