8zugvM4P

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