CREATE TABLE "GUESTS" (
	"Guest_Id" int PRIMARY KEY,
	"Fname" varchar(255),
	"Mname" varchar(255),
	"Lname" varchar(255),
	"Sex" varchar(255),
	"Nationality" varchar(255)
);
CREATE TABLE "RESERVATION" (
	"Reservation_Code" int PRIMARY KEY,
	"Guest_Id" int,
	"Date" datetime,
	"Check-In_Date" datetime,
	"Check-Out_Date" datetime,
	"IsCancelled" bool,
	"Payment" varchar,
	FOREIGN KEY("Guest_Id") REFERENCES "GUESTS" ("Guest_Id")
);
CREATE TABLE "ROOMS" (
	"Room_No" int PRIMARY KEY,
	"RoomType_Code" varchar(255),
	"Floor_No" int,
	"IsOccupied" bool,
	"Free_Date" datetime,
	"Reservation_Code" int,
	FOREIGN KEY("RoomType_Code") REFERENCES "ROOM_TYPES" ("RoomType_Code"),
	FOREIGN KEY("Reservation_Code") REFERENCES "RESERVATION" ("Reservation_Code")
);
CREATE TABLE "ROOM_TYPES" (
	"RoomType_Code" int PRIMARY KEY,
	"RoomType_Name" varchar(255),
	"Amenities" varchar(255),
	"Capacity" varchar(255),
	"Rate" varchar(255)
);