aUN2hdTk

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