---

-- 1. Создание таблицы номеров
CREATE TABLE "Hotel_Rooms" (
    "Room_Number" INT NOT NULL PRIMARY KEY,
    "Room_Type" VARCHAR(50),
    "Is_Free" BOOLEAN DEFAULT TRUE
);

-- 2. Создание таблицы бронирований
CREATE TABLE "Bookings" (
    "Booking_ID" INT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
    "Room_Number" INT,
    "Guest_Name" VARCHAR(100),
    "Paid_Amount" DECIMAL(10, 2),
    FOREIGN KEY ("Room_Number") REFERENCES "Hotel_Rooms"("Room_Number")
);

-- 3. Заполнение исходных данных (Номер 101, «Люкс», свободен)
INSERT INTO "Hotel_Rooms" ("Room_Number", "Room_Type", "Is_Free") 
VALUES (101, 'Люкс', TRUE);