TABLES

TABLE DESIGN
TABLE NAME : Busdetails
PRIMARY KEY : Bcount.

FIELD NAME DATA TYPE DESCRIPTION

Bcount Int Bus count
bname Varchar Bus name
seats Int Total seats
ac Varchar Ac
busno Varchar Bus no
busimage Image Bus image

TABLE NAME : Customizedbooing

PRIMARY KEY : bookingno

FIELD NAME DATA TYPE DESCRIPTION

bookingno Int Purchase id
cname Varchar Customer name
Insti Varchar Institution
address Varchar Address
contactno Varchar Contact no
Pickup Varchar Place
source Double Source
destination DateTime Destination
Places Varchar Places
Jdate Date time Journey date
Tdays Int Total days
Busno Int Bus no
Busname Varchar Bus name
initialamount Double Initial amount

TABLE NAME : employee

PRIMARY KEY : eid
FIELD NAME DATA TYPE DESCRIPTION
Eid Int Employee id
ename Varchar Employee name
gender Varchar Gender
age Int Age
address Varchar Address
contactno Varchar Contact no
bsalary Varchar Basic salary
TABLE NAME : featuretour
Primary key : packno

FIELD NAME DATA TYPE DESCRIPTION

Packno Int Package no
Ptype Varchar Package type
zone Varchar Zone
place Varchar Place
placeImage Image Image
fare Double Fare
aboutplace Varchar Place description

TABLE NAME : featuretourbooking

PRIMARY KEY : bookingno
FIELD NAME DATA TYPE DESCRIPTION
Bookingno Int Booking no
Cname Varchar Name
ptype Varchar Package type
zone Varchar Zone
totalmembers Int Total members
totalfare Double Total fare
jdate Date time Journey date
bookeddate Date time Booking date

TABLE NAME : feedback

FIELD NAME DATA TYPE DESCRIPTION
Cname Varchar Customer name
address Varchar Address
contactno Varchar Contact no
city Varchar City
gname Varchar Guide name
feedback Varchar Feedback
comments Varchar comments

TABLE NAME : Guideallocation

Foreign key : empid
FIELD NAME DATA TYPE DESCRIPTION
empid Varchar Employee id
empname Varchar Name
L1 Varchar Language 1
L2 Varchar Language 2
L3 Varchar Language 3
L4 Varchar Language 4
L5 Varchar Language 5
L6 Varchar Language 6
workingin Varchar Working in
TABLE NAME : hotelbooking
Foreign key : Bno
FIELD NAME DATA TYPE DESCRIPTION
Bno Int Booking no
Place Varchar Place
hname Varchar Hotel name
rtype Varchar Room type
ac Varchar Ac
dayrent Double Per day rent
tamount Double Total amount
cname Varchar Customer name
Bdate Date time Booking date
Fromdate Date time From date
Todate Date time To date

TABLE NAME : hoteldetails

Foreign key : hotelid
FIELD NAME DATA TYPE DESCRIPTION
Hotelid Int Hotel id
hname Varchar Hotel name
himage Image Image
Zone Varchar Zone
place Varchar Place
descr Double Description
TABLE NAME : hoteldetails
Foreign key : hotelid
FIELD NAME DATA TYPE DESCRIPTION
Bno Int Booking no
tname Varchar Theater name
fname Varchar Film name
cname Varchar Customer name
fc Varchar First class
Sc Varchar Second class
Totalseats Int Total seats
Bookdate Date time Booking date
Showtime Varchar Show time
showdate Date time Show date

TABLE NAME : register

Primary key : regid
FIELD NAME DATA TYPE DESCRIPTION
regid Int Registration id
cname Varchar Customer name
address Varchar Address
contactno Varchar Contact no
city Varchar City
secquestion Varchar Secret question
secanswer Varchar Secret answer
loginid Varchar Login id
pwd Varchar Password
Repwd Varchar Retype password
Regdate Date time Register date
emailid Varchar Email id
TABLE NAME : roomdetails
Foreign key : hotelid
FIELD NAME DATA TYPE DESCRIPTION
Hotelid Int Hotel id
Hname Varchar Hotel name
type Varchar Type
ac Varchar Ac
perdayRent Double Per day rent

TABLE NAME : theaterdetails

Foreign key : tno
FIELD NAME DATA TYPE DESCRIPTION
Tno Int Theater no
tname Varchar Theater name
timage Varchar Theater image

TABLE NAME : theaterdetails

Foreign key : tno
FIELD NAME DATA TYPE DESCRIPTION
Tno Int Theater no
tname Varchar Theater name
timage Varchar Theater image
TABLE NAME : tourpackage
Foreign key : packno
FIELD NAME DATA TYPE DESCRIPTION
Packno Int Package no
Source Varchar Source
Desti Varchar Destination
Place Varchar Place
Placeimage Image Image
Bname Varchar Bus name
Fare Double Fare
Tseats Int Total seats
date Date time Date
Depttime Varchar Departure time
duration Varchar duration
TABLE NAME : tourbooking
Primary key : bno
FIELD NAME DATA TYPE DESCRIPTION
bno Int booking no
Source Varchar Source
Desti Varchar Destination
places Varchar Place
cname Varchar Customer name
jdate Date time Journey date
Fare Double Fare
Tseats Int Total seats
totalamount Double Total amount
Depttime Varchar Departure time
Bookingdate Varchar Booking date
Guide Varchar Guide
Regid Varchar Register id
packageno Varchar Package no

TABLE NAME : weather

Foreign key : city
FIELD NAME DATA TYPE DESCRIPTION
City Varchar City
Sunny Varchar Sunny
Rainy Varchar Rainy
humidity Varchar humidity