Scribd
Upload
14 views2 pages

Travel Booking Database Schema

The document outlines a database schema for managing travel itineraries, bookings, reviews, customers, and destinations. It includes various attributes such as BookingID, CustomerID, DestinationID, and associated details like ratings, comments, and travel preferences. The structure is designed to facilitate the organization and retrieval of travel-related information.

Uploaded by

zeroperiodog
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
14 views2 pages

Travel Booking Database Schema

The document outlines a database schema for managing travel itineraries, bookings, reviews, customers, and destinations. It includes various attributes such as BookingID, CustomerID, DestinationID, and associated details like ratings, comments, and travel preferences. The structure is designed to facilitate the organization and retrieval of travel-related information.

Uploaded by

zeroperiodog
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Itineraries

ItineraryID int

Reviews
*
BookingID int

ReviewID int DayNumber int Destinations


* 1 0..1
BookingID int Activity text DestinationID int

Rating int DestinationName varchar(100)

Comment text Country varchar(50)


Bookings
ReviewDate date Description text
1 1
BookingID int
*
CustomerID int
*
DestinationID int
DestinationCategory
BookingDate date *
DestinationID int
TravelDate date *
CategoryID int
Budget decimal(10,2)
Customers
1
CustomerID int

FullName varchar(100) Categories


0..1
Email varchar(100) CategoryID int

Phone varchar(15) CategoryName varchar(50)

TravelPreference varchar(100)
Itineraries

ItineraryID int

Reviews
*
BookingID int

ReviewID int DayNumber int Destinations


* 1 0..1
BookingID int Activity text DestinationID int

Rating int DestinationName varchar(100)

Comment text Country varchar(50)


Bookings
ReviewDate date Description text
1 1
BookingID int
*
CustomerID int
*
DestinationID int
DestinationCategory
BookingDate date *
DestinationID int
TravelDate date *
CategoryID int
Budget decimal(10,2)
Customers
1
CustomerID int

FullName varchar(100) Categories


0..1
Email varchar(100) CategoryID int

Phone varchar(15) CategoryName varchar(50)

TravelPreference varchar(100)

You might also like