Eg2wu1XN

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