{"Rooms": {"columns": [[0, "RoomId", "TEXT", 0, null, 1], [1, "roomName", "TEXT", 0, null, 0], [2, "beds", "INTEGER", 0, null, 0], [3, "bedType", "TEXT", 0, null, 0], [4, "maxOccupancy", "INTEGER", 0, null, 0], [5, "basePrice", "INTEGER", 0, null, 0], [6, "decor", "TEXT", 0, null, 0]], "primary_keys": ["RoomId"], "foreign_keys": [], "unique_constraints": [[[0, 0, "RoomId"]]], "check_constraints": []}, "Reservations": {"columns": [[0, "Code", "INTEGER", 0, null, 1], [1, "Room", "TEXT", 0, null, 0], [2, "CheckIn", "TEXT", 0, null, 0], [3, "CheckOut", "TEXT", 0, null, 0], [4, "Rate", "REAL", 0, null, 0], [5, "LastName", "TEXT", 0, null, 0], [6, "FirstName", "TEXT", 0, null, 0], [7, "Adults", "INTEGER", 0, null, 0], [8, "Kids", "INTEGER", 0, null, 0]], "primary_keys": ["Code"], "foreign_keys": [[0, 0, "Rooms", "Room", "RoomId", "NO ACTION", "NO ACTION", "NONE"]], "unique_constraints": [], "check_constraints": ["\"CheckIn\" TEXT,", "\"CheckOut\" TEXT,"]}}
CREATE TABLE Rooms (
    RoomId TEXT   PRIMARY KEY,
    roomName TEXT,
    beds INTEGER,
    bedType TEXT,
    maxOccupancy INTEGER,
    basePrice INTEGER,
    decor TEXT,
    UNIQUE (RoomId)
);

CREATE TABLE Reservations (
    Code INTEGER   PRIMARY KEY,
    Room TEXT,
    CheckIn TEXT,
    CheckOut TEXT,
    Rate REAL,
    LastName TEXT,
    FirstName TEXT,
    Adults INTEGER,
    Kids INTEGER,
    FOREIGN KEY (Room) REFERENCES Rooms(RoomId),
    "CheckIn" TEXT,,
    "CheckOut" TEXT,
);