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 CONSTRAINT GUESTS_Guest_Id REFERENCES GUESTS(Guest_Id),
	"Date" datetime,
	"Check-In_Date" datetime,
	"Check-Out_Date" datetime,
	"IsCancelled" bool,
	"Payment" varchar
);
CREATE TABLE "ROOMS" (
	"Room_No" int PRIMARY KEY,
	"RoomType_Code" varchar(255) CONSTRAINT ROOM_TYPES_RoomType_Code REFERENCES ROOM_TYPES(RoomType_Code),
	"Floor_No" int,
	"IsOccupied" bool,
	"Free_Date" datetime,
	"Reservation_Code" int CONSTRAINT RESERVATION_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)
);