QV72JYSf

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    row_id         BIGINT REFERENCES rows (id)         NOT NULL,
12    reservation_id BIGINT REFERENCES reservations (id) NOT NULL,
13    is_available   BOOLEAN                             NOT NULL,
14    screening_id   BIGINT REFERENCES screenings (id)   NOT NULL
15);
16
17CREATE TABLE IF NOT EXISTS reservations
18(
19    id          BIGINT PRIMARY KEY,
20    username    VARCHAR(30) NOT NULL,
21    surname     VARCHAR(30) NOT NULL,
22    expire_time timestamp   NOT NULL
23);
24
25CREATE TABLE IF NOT EXISTS screenings
26(
27    id             BIGINT PRIMARY KEY,
28    movie_id       BIGINT REFERENCES movies (id)          NOT NULL,
29    screening_time DATE                                   NOT NULL,
30    room_id        BIGINT REFERENCES screening_rooms (id) NOT NULL,
31    ticket_price   NUMERIC(15, 2)                         NOT NULL
32);
33
34CREATE TABLE IF NOT EXISTS screening_rooms
35(
36    id        BIGINT PRIMARY KEY,
37    room_name VARCHAR(30) NOT NULL
38);
39
40CREATE TABLE IF NOT EXISTS rows
41(
42    id                BIGINT PRIMARY KEY,
43    screening_room_id BIGINT REFERENCES screening_rooms (id) NOT NULL
44)