CREATE TABLE [Reservation](
	[ReservationId] [int] IDENTITY(1,1) NOT NULL,
	[RoomId] [int] NOT NULL,
	[ReservationName] [nvarchar](100) NOT NULL,
	[ReservationPaid] [int] NOT NULL,
	[ReservationStatus] [int] NOT NULL,
	[ReservationStart] [datetime] NOT NULL,
	[ReservationEnd] [datetime] NOT NULL
);
CREATE TABLE [Room](
	[RoomId] [int] IDENTITY(1,1) NOT NULL,
	[RoomName] [nvarchar](100) NOT NULL,
	[RoomStatus] [nvarchar](10) NOT NULL,
	[RoomSize] [int] NOT NULL
);