Lasta travel database

USE [lasta_travel]
GO
/****** Object:  Table [dbo].[Cities]    Script Date: 5/21/2018 12:46:32 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Cities](
    [Id] [INT] IDENTITY(1,1) NOT NULL,
    [cName] [nvarchar](30) NULL,
    [ImageURL] [nvarchar](60) NULL,
    [CountriesId] [INT] NULL,
PRIMARY KEY CLUSTERED
(
    [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Cities_TourDays]    Script Date: 5/21/2018 12:46:33 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Cities_TourDays](
    [Id] [INT] IDENTITY(1,1) NOT NULL,
    [CitiesId] [INT] NULL,
    [TourDaysId] [INT] NULL,
PRIMARY KEY CLUSTERED
(
    [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Countries]    Script Date: 5/21/2018 12:46:33 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Countries](
    [Id] [INT] IDENTITY(1,1) NOT NULL,
    [CountryName] [nvarchar](30) NULL,
    [FlagImageURL] [nvarchar](60) NULL,
    [CoatOfArmsURL] [nvarchar](60) NULL,
    [AboutCountry] [nvarchar](MAX) NULL,
PRIMARY KEY CLUSTERED
(
    [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ImportantNumbers]    Script Date: 5/21/2018 12:46:33 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ImportantNumbers](
    [Id] [INT] IDENTITY(1,1) NOT NULL,
    [InstitutionName] [nvarchar](40) NULL,
    [NUMBER] [nvarchar](30) NULL,
    [LocationLat] [nvarchar](30) NULL,
    [LocationLng] [nvarchar](30) NULL,
    [CountriesId] [INT] NULL,
PRIMARY KEY CLUSTERED
(
    [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Menu]    Script Date: 5/21/2018 12:46:33 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Menu](
    [Id] [INT] IDENTITY(1,1) NOT NULL,
    [TourLocationId] [INT] NULL,
PRIMARY KEY CLUSTERED
(
    [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[MenuItem]    Script Date: 5/21/2018 12:46:33 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[MenuItem](
    [Id] [INT] IDENTITY(1,1) NOT NULL,
    [miName] [nvarchar](30) NULL,
    [Price] [DECIMAL](18, 0) NULL,
    [MenuId] [INT] NULL,
PRIMARY KEY CLUSTERED
(
    [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Schedules]    Script Date: 5/21/2018 12:46:33 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Schedules](
    [Id] [INT] IDENTITY(1,1) NOT NULL,
    [Title] [nvarchar](30) NULL,
    [sDescription] [nvarchar](130) NULL,
    [sTime] [TIME](7) NULL,
    [TourDaysId] [INT] NULL,
    [TourLocationId] [INT] NULL,
PRIMARY KEY CLUSTERED
(
    [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TourDays]    Script Date: 5/21/2018 12:46:33 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TourDays](
    [Id] [INT] IDENTITY(1,1) NOT NULL,
    [TourDayDate] [DATE] NULL,
    [TripId] [INT] NULL,
PRIMARY KEY CLUSTERED
(
    [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TourLeaders]    Script Date: 5/21/2018 12:46:33 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TourLeaders](
    [Id] [INT] IDENTITY(1,1) NOT NULL,
    [FirstName] [nvarchar](30) NULL,
    [LastName] [nvarchar](30) NULL,
    [PictureURL] [nvarchar](60) NULL,
    [PhoneNumber] [nvarchar](30) NULL,
    [Email] [nvarchar](30) NULL,
    [AboutTl] [nvarchar](MAX) NULL,
PRIMARY KEY CLUSTERED
(
    [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TourLocation]    Script Date: 5/21/2018 12:46:33 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TourLocation](
    [Id] [INT] IDENTITY(1,1) NOT NULL,
    [tlName] [nvarchar](30) NULL,
    [tlText] [nvarchar](MAX) NULL,
    [WorkingHoursStart] [TIME](7) NULL,
    [WorkingHoursEnd] [TIME](7) NULL,
    [LocationLat] [nvarchar](30) NULL,
    [LocationLng] [nvarchar](30) NULL,
    [IsRecommended] [bit] NULL,
    [TourLocationTypeId] [INT] NULL,
PRIMARY KEY CLUSTERED
(
    [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TourLocationImages]    Script Date: 5/21/2018 12:46:33 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TourLocationImages](
    [Id] [INT] IDENTITY(1,1) NOT NULL,
    [ImageURL] [nvarchar](60) NULL,
    [TourLocationId] [INT] NULL,
PRIMARY KEY CLUSTERED
(
    [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TourLocationType]    Script Date: 5/21/2018 12:46:33 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TourLocationType](
    [Id] [INT] IDENTITY(1,1) NOT NULL,
    [tltTitle] [nvarchar](30) NULL,
PRIMARY KEY CLUSTERED
(
    [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Transport]    Script Date: 5/21/2018 12:46:33 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Transport](
    [Id] [INT] IDENTITY(1,1) NOT NULL,
    [tName] [nvarchar](30) NULL,
    [PhoneNumber] [nvarchar](30) NULL,
    [SiteURL] [nvarchar](30) NULL,
    [ImageURL] [nvarchar](30) NULL,
    [IsRecommended] [bit] NULL,
    [CitiesId] [INT] NULL,
    [TrasportTypeId] [INT] NULL,
PRIMARY KEY CLUSTERED
(
    [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TransportType]    Script Date: 5/21/2018 12:46:33 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TransportType](
    [Id] [INT] IDENTITY(1,1) NOT NULL,
    [ttName] [nvarchar](30) NULL,
PRIMARY KEY CLUSTERED
(
    [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Trip]    Script Date: 5/21/2018 12:46:33 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Trip](
    [Id] [INT] IDENTITY(1,1) NOT NULL,
    [tName] [nvarchar](30) NULL,
    [DateFrom] [DATE] NULL,
    [DateTo] [DATE] NULL,
PRIMARY KEY CLUSTERED
(
    [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Trip_TourLeaders]    Script Date: 5/21/2018 12:46:33 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Trip_TourLeaders](
    [Id] [INT] IDENTITY(1,1) NOT NULL,
    [TripId] [INT] NULL,
    [TourLeadersId] [INT] NULL,
PRIMARY KEY CLUSTERED
(
    [Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[Cities]  WITH CHECK ADD FOREIGN KEY([CountriesId])
REFERENCES [dbo].[Countries] ([Id])
GO
ALTER TABLE [dbo].[Cities_TourDays]  WITH CHECK ADD FOREIGN KEY([CitiesId])
REFERENCES [dbo].[Cities] ([Id])
GO
ALTER TABLE [dbo].[Cities_TourDays]  WITH CHECK ADD FOREIGN KEY([TourDaysId])
REFERENCES [dbo].[TourDays] ([Id])
GO
ALTER TABLE [dbo].[ImportantNumbers]  WITH CHECK ADD FOREIGN KEY([CountriesId])
REFERENCES [dbo].[Countries] ([Id])
GO
ALTER TABLE [dbo].[Menu]  WITH CHECK ADD FOREIGN KEY([TourLocationId])
REFERENCES [dbo].[TourLocation] ([Id])
GO
ALTER TABLE [dbo].[MenuItem]  WITH CHECK ADD FOREIGN KEY([MenuId])
REFERENCES [dbo].[Menu] ([Id])
GO
ALTER TABLE [dbo].[Schedules]  WITH CHECK ADD FOREIGN KEY([TourDaysId])
REFERENCES [dbo].[TourDays] ([Id])
GO
ALTER TABLE [dbo].[Schedules]  WITH CHECK ADD FOREIGN KEY([TourLocationId])
REFERENCES [dbo].[TourLocation] ([Id])
GO
ALTER TABLE [dbo].[TourDays]  WITH CHECK ADD FOREIGN KEY([TripId])
REFERENCES [dbo].[Trip] ([Id])
GO
ALTER TABLE [dbo].[TourLocation]  WITH CHECK ADD FOREIGN KEY([TourLocationTypeId])
REFERENCES [dbo].[TourLocationType] ([Id])
GO
ALTER TABLE [dbo].[TourLocationImages]  WITH CHECK ADD FOREIGN KEY([TourLocationId])
REFERENCES [dbo].[TourLocation] ([Id])
GO
ALTER TABLE [dbo].[Transport]  WITH CHECK ADD FOREIGN KEY([CitiesId])
REFERENCES [dbo].[Cities] ([Id])
GO
ALTER TABLE [dbo].[Transport]  WITH CHECK ADD FOREIGN KEY([TrasportTypeId])
REFERENCES [dbo].[TransportType] ([Id])
GO
ALTER TABLE [dbo].[Trip_TourLeaders]  WITH CHECK ADD FOREIGN KEY([TourLeadersId])
REFERENCES [dbo].[TourLeaders] ([Id])
GO
ALTER TABLE [dbo].[Trip_TourLeaders]  WITH CHECK ADD FOREIGN KEY([TripId])
REFERENCES [dbo].[Trip] ([Id])
GO