Here we shared Travel Agency Management System Table design. This project has 25 tables. The tables are admin, amenities, billing, boardingpoints, booking, bus, cancellation, company, customer, flight, hotel, hotel_image, location, rating, room, roomtype, room_booking, service, tourpackage, tourpackage_itinerary, tourpackage_place, tourpackage_travel_options, train, train_type.

Database name : travel_agency


Travel Agency Management System Table design

Table Name:  admin

Column Type Index
adminid int(10) No
adminname varchar(25) No
loginid varchar(25) No
password varchar(50) No
status varchar(10) No

Table Name:  amenities

Column Type Index
amenitiesid int(10) No
busid int(10) No
amenities varchar(25) No
icon varchar(100) No
status varchar(10) No

Table Name:  billing

Column Type Index
billingid int(10) No
customerid int(10) No
billingcost float(10,2) No
tax float(10,2) No
date date No
payment_type varchar(20) No
cardno varchar(25) No
status varchar(20) No

Table Name: boardingpoints

Column Type Index
boardingpointid int(10) No
busid int(10) No
boardingpointno int(10) No
slocation varchar(50) No
dlocation varchar(50) No
arrivaltime datetime No
departuretime datetime No
seatercost float(10,2) No
sleepercost float(10,2) No
status varchar(10) No

Table Name:  booking

Column Type Index
bookingid int(10) No
billingid int(10) No
bookingtype varchar(20) No
ticketid int(10) No
seatno varchar(25) No
passengername varchar(25) No
gender varchar(10) No
contact varchar(15) No
status varchar(10) No

Table Name:  bus

Column Type Index
busid int(10) No
companyid int(10) No
bustype varchar(25) No
sleeperseats int(10) No
seaterseats int(10) No
status varchar(10) No

Table Name:  cancellation

Column Type Index
cancellation_id int(10) No
billingid int(10) No
refundamount float(10,2) No
cancellationdate date No
status varchar(10) No

Table Name:  company

Column Type Index
companyid int(10) No
companytype varchar(20) No
companyname varchar(25) No
companylogo varchar(100) No
description text No
status varchar(10) No

Table Name:  customer

Column Type Index
customerid int(10) No
customername varchar(25) No
dob date No
gender varchar(10) No
address varchar(500) No
contact varchar(20) No
mobile varchar(20) No
state varchar(20) No
country varchar(25) No
pincode varchar(10) No
emailid varchar(20) No
loginid varchar(20) No
password varchar(50) No
status varchar(10) No

Table Name:  flight

Column Type Index
flightid int(10) No
companyid int(10) No
dlocationid int(10) No
alocationid int(10) No
duration varchar(25) No
departtime datetime No
arrivetime datetime No
economyseats int(10) No
businessseats int(10) No
firstclassseats int(10) No
premiumeconomyseats int(10) No
econ_tariff float(10,2) No
business_tariff float(10,2) No
firstclass_tariff float(10,2) No
premium_tariff float(10,2) No
description text No
status varchar(10) No

Table Name:  hotel

Column Type Index
hoteid int(10) No
companyid int(10) No
locationid int(10) No
hotelname varchar(25) No
hoteladdress varchar(250) No
pincode varchar(50) No
landmark varchar(50) No
hoteldescription text No

Table Name: hotel_image

Column Type Index
hotel_image_id int(10) No
hotelid int(10) No
hotel_image varchar(50) No
hotel_image_description text No

Table Name:  location

Column Type Index
locationid int(10) No
location varchar(25) No
locationtype varchar(25) No
locationtitle varchar(100) No
description text No
status varchar(10) No

Table Name:  rating

Column Type Index
ratingid int(10) No
ratingtype varchar(25) No
customerid int(10) No
companyid int(10) No
rating int(10) No
commenttitle varchar(100) No
comments text No
ratingdate date No
status varchar(10) No

Table Name:  room

Column Type Index
roomid int(10) No
roomno varchar(30) No
roomtypeid int(10) No
status varchar(10) No

Table Name: roomtype

Column Type Index
roomtypeid int(10) No
hoteid int(10) No
roomtype varchar(50) No
note text No
roomtariff float(10,2) No
status varchar(10) No

Table Name: room_booking

Column Type Index
room_booking_id int(10) No
billingid int(10) No
customerid int(10) No
roomid int(10) No
checkindate datetime No
checkoutdate datetime No
noofadults int(10) No
noofchildren int(10) No
status varchar(10) No

Table Name:  service

Column Type Index
serviceid int(10) No
hoteid int(10) No
servicetype varchar(50) No
servicetitle varchar(100) No
description text No
image varchar(100) No
cost float(10,2) No
tariff_type varchar(25) No
unit varchar(25) No
status varchar(10) No

Table Name: tourpackage

Column Type Index
tour_package_id int(10) No
companyid int(10) No
tourpackagetype varchar(25) No
packagetitle varchar(100) No
videolink varchar(100) No
imagelink varchar(100) No
overview text No
inclusion text No
no_of_days varchar(50) No
minprice float(10,2) No

Table Name: tourpackage_itinerary

Column Type Index
itineraryid int(10) No
tour_package_id int(10) No
day_no int(10) No
itinerary_title varchar(100) No
itinerary_description text No
itinerary_image varchar(100) No

Table Name: tourpackage_place

Column Type Index
tourpackage_place_id int(10) No
tourpackage_id int(10) No
about_place text No
place_map text No
contact varchar(25) No
status varchar(10) No

Table Name: tourpackage_travel_options

Column Type Index
travel_option_id int(10) No
tour_package_id int(10) No
travel_source_loc varchar(25) No
travel_destination_loc varchar(25) No
travel_type varchar(25) No
note text No

Table Name:  train

Column Type Index
trainid int(10) No
trainname varchar(25) No
traintype varchar(25) No
sleeperseats int(10) No
seaterseats int(10) No
status varchar(25) No

Table Name: train_type

Column Type Index
train_type_id int(10) No
trainid int(10) No
boardingpointno int(10) No
slocation varchar(50) No
dlocation varchar(50) No
arrivaltime datetime No
departuretime datetime No
seatercost float(10,2) No
sleepercost float(10,2) No
status varchar(10) No

DOWNLOAD Travel Agency Management System Table design


Refer this LINK for video tutorials..

🔥2.2 K Views

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.