Tours:
CREATE TABLE [dbo].[Tours] (
[Id] INT IDENTITY (1, 1) NOT NULL,
[HotelID] INT NOT NULL,
[FromDate] DATE NOT NULL,
[ToDate] DATE NOT NULL,
[Price] INT NOT NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);
Cities:
CREATE TABLE [dbo].[Cities] (
[Id] INT IDENTITY (1, 1) NOT NULL,
[Name] NVARCHAR (90) NOT NULL,
[CountryID] INT NOT NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);
Countrys:
CREATE TABLE [dbo].[Countrys] (
[Id] INT IDENTITY (1, 1) NOT NULL,
[Name] NVARCHAR (90) NOT NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);
Hotels:
CREATE TABLE [dbo].[Hotels] (
[Id] INT IDENTITY (1, 1) NOT NULL,
[City] INT NOT NULL,
[Rating] INT NOT NULL,
[Name] NVARCHAR (60) NOT NULL,
[DistanceToBeach] INT NULL,
[Line] INT NULL,
[DistanceToAirport] INT NOT NULL,
[Discription] NVARCHAR (MAX) NOT NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);
HotelsRooms:
CREATE TABLE [dbo].[HotelsRooms] (
[Id] INT IDENTITY (1, 1) NOT NULL,
[HotelID] INT NOT NULL,
[roomTypeID] INT NOT NULL,
[price] INT NOT NULL,
[count] INT NOT NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);
HotelsRommTypes:
CREATE TABLE [dbo].[HotelRoomTypes] (
[Id] INT IDENTITY (1, 1) NOT NULL,
[SingleBeds] INT NULL,
[DoubleBeds] INT NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);