v7sDkmiH

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