delivers-the-latest-Kerala-kollad-kottayam-erankulam-kochi-Chennai-Mumbai-Delhi-Bangalore-breaking-news-and-information-on the-latest-top-stories,weat

Database hbs
Table structure for table account
Field Type Null Default
ACCOUNT_ROWID smallint(12) Yes NULL
ACCOUNT_QUATATIONROWID smallint(12) Yes
ACCOUNT_ROMROWID smallint(12) Yes
ACCOUNT_COMMISIONRATE float Yes
Table structure for table commisionmaster
Field Type Null Default
COMMISION_ROWID smallint(12) Yes NULL
COMMISION_HOTELROWID smallint(12) Yes
COMMISION_ROOMROWID smallint(12) Yes
COMMISION_RATE float Yes
Table structure for table destination
Field Type Null Default
DESTNATION_ROWID smallint(12) Yes NULL

DESTINATION_DESC varchar(50) Yes
Table structure for table enquiry
Field Type Null Default
ENQUIRY_ROWID smallint(12) Yes NULL
ENQUIRY_CUSTNAME varchar(250) Yes
ENQUIRY_TOTMEMBERS int(12) Yes
ENQUIRY_ADULTS smallint(12) Yes
ENQUIRY_CHILDREN smallint(12) Yes
ENQUIRY_CUSTEMAIL varchar(25) Yes
ENQUIRY_CUSTPHONE varchar(25) Yes
ENQUIRY_CUSTMOBILE varchar(25) Yes
ENQUIRY_CUSTCARHIRE smallint(5) Yes
ENQUIRY_CUSTGUIDESTAT smallint(5) Yes
ENQUIRY_HOTELROOMID smallint(12) Yes
ENQUIRY_ENQUIRYTYPE(childid) smallint(12) Yes
ENQUIRY_CHECKINTIME datetime Yes
ENQUIRY_CHECKOUTTIME datetime Yes
ENQUIRY_TIME datetime Yes
Table structure for table enquiryhotels
Field Type Null Default
ENQUIRYHOTEL_ROWID smallint(12) Yes NULL
ENQUIRYHOTEL_HOTELROWID smallint(12) Yes
ENQUIRYHOTEL_ENQUIRYROWID(fk enquiry) smallint(12) Yes
ENQUIRYHOTEL_ELAPSETIME datetime Yes
Table structure for table facility
Field Type Null Default
FACILITY_ROWID smallint(12) Yes NULL
FACILITY_HOTELROWID(fk hoteldetail) smallint(12) Yes
FACILITY_DESC varchar(250) Yes
Table structure for table hotel_roomtype
Field Type Null Default
ROOM_ROWID smallint(12) Yes NULL
ROOM_HOTELROWID(fk hoteldetail) smallint(12) Yes
ROOM_ROOMTYPE (childid) smallint(12) Yes
ROOM_STARRATE(childid) smallint(12) Yes
ROOM_PRICE float Yes
ROOM_FACILITY varchar(250) Yes






Table structure for table hoteldetail
Field Type Null Default
HOTEL_ROWID smallint(12) Yes NULL
HOTEL_NAME varchar(50) Yes
HOTEL_ADD varchar(150) Yes
HOTEL_STATUS(childid) smallint(12) Yes
HOTEL_RATE (childid) smallint(12) Yes
HOTEL_TYPE(childid) smallint(12) Yes
HOTEL_ DESTNATION_ROWID(fk destination) varchar(50) Yes
HOTEL_SEASONAL varchar(50) Yes
HOTEL_NONSEASONAL varchar(50) Yes
HOTEL_EMAIL varchar(25) Yes
HOTEL_FACILITY varchar(250) Yes
HOTEL_DESCRIPTION varchar(250) Yes

Table structure for table hotelimage
Field Type Null Default
IMAGE_ROWID smallint(12) Yes NULL
IMAGE_HOTELROWID(fk hoteldetail) smallint(12) Yes
IMAGE_THUMB varchar(150) Yes
IMAGE_ORIGINAL varchar(150) Yes

Table structure for table master (table for keeping all master table)
Field Type Null Default
MAST_ROWID smallint(6) Yes NULL
MAST_DESCRIPTION varchar(50) Yes
MAST_TYPE varchar(5) Yes
Dumping data for table master
1 5star hr
2 3star hr
3 economic hs
4 luxuary hs
5 resort ht
6 cottage ht
7 cottage ht
8 hot et
9 warm et
10 cool et
11 Roomluxuary RL
12 Roomdelux RD
Table structure for table quation_confirmation
Field Type Null Default
QUATATION_ROWID smallint(12) Yes NULL
QUATATION_ENQUIRYROWID smallint(12) Yes
QUATATION_HOTELROOMROWID smallint(12) Yes
QUATATION_HOTELROWID(fk hoteldetail) smallint(12) Yes
QUATATION_RATE float Yes
QUATATION_STATUS smallint(12) Yes