cFqG0i7x

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);
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 seats
25(
26    seat_number  INTEGER                      NOT NULL,
27    "row_number" INTEGER                      NOT NULL,
28    room_id      BIGINT REFERENCES rooms (id) NOT NULL,
29    PRIMARY KEY (seat_number, "row_number", room_id)
30);
31
32CREATE TABLE IF NOT EXISTS reserved_seats
33(
34    seat_number    BIGINT                              NOT NULL,
35    "row_number"   BIGINT                              NOT NULL,
36    reservation_id BIGINT REFERENCES reservations (id) NOT NULL,
37    screening_id   BIGINT REFERENCES screenings (id)   NOT NULL,
38    FOREIGN KEY (seat_number, "row_number") REFERENCES seats (seat_number, "row_number"),
39    PRIMARY KEY (seat_number, "row_number", screening_id)
40);