SERVICE_SELECTION

service_selection_id PK
category

OFFER
offer_id PK
offer_details
service_id FK

SCHEDULE_APPOINTMENT
Sschedule_app_id PK
user_id
selected_package_id FK
address
time_slot
payment_method
 STAYS
stay_id PK
stay_name
location
category
price
rating
total_rooms
available_rooms

FLIGHT_HOTEL_PACKAGES
flight_hotel_package_id PK
departure_airport FK
date_time FK
travellers
flight_class
package_price
destination
 PROPERTIES
property_id PK
owner_id FK
property_name
address
facilities
price_per_night

USER
user_id PK
name
email
phone
password_hash

DRIVERS
driver_id PK
name
phone
vehicle_id FK
rating
license_no

BOOKING_HISTORY
booking_history_id PK
user_id FK
ride_id FK
rental_id FK
booking_status

BOOKINF_SECTION
booking_id PK
pickup_location
drop_location
phone_number
shifting_date
time_slot
price

BOKKING_SERVICES
booking_id FK
service_id FK
 SERVICE_SELECTION S

VARCHAR(10)Autoincrement subcategory_id
varchar(20) service_selection_id
subcategory_name

OFFER MOS
VARCHAR(10)Autoincrement most_booked_service_id
VARCHAR(100) browser_service_id
VARCHAR(10) service_name

CHEDULE_APPOINTMENT
VARCHAR(10)Autoincrement cart_id
VARCHAR(10) user_id
VARCHAR(10) selected_package_id
VARCHAR(100) total_price
DATETIME discount_code
VARCHAR(10)

HOME_OFFICE_SERVICES
home_service_id PK
service_name
 BOOKING
booking_id PK
user_id
selected_package_id FK
address
time_slot
payment_method
status

STAYS
VARCHAR(10)Autoincrement booking_id
varchar(20) user_id
VARCHAR(60) stay_id
ENUM checkin_date
DECIMAL(10,2) checkout_date
FLOAT adults
INT children
BOOLEAN total_price
payment_id
status

LIGHT_HOTEL_PACKAGES
VARCHAR(10)Autoincrement
VARCHAR(20)
DATETIME car_rent_id
INT car_type
ENUM pickup_location
DECIMAL(10,2) rental_price
VARCHAR(20) rental_company
rating
availability
price_per_day
 PROPERTIES
VARCHAR(10)Autoincrement currencies_id
VARCHAR(10) currency_code
VARCHAR(20) currency_name
VARCHAR(100)
VARCHAR(100)
DECIMAL(10,2)

USER
VARCHAR(10)Autoincrement ride_booking_id
varchar(20) user_id
VARCHAR(60) pickup_location
VARCHAR(15) drop_location
VARCHAR(100) booking_time
ride_status
schedule_date
price
driver_id
payment_id

DRIVERS
VARCHAR(10)Autoincrement ride_fare_id
VARCHAR(20) ride_id
VARCHAR(15) base_fare
VARCHAR(10) user_offer
FLOAT final_fare
VARCHAR(50) status

CU
BOOKING_HISTORY customer_support_id
VARCHAR(10)Autoincrement user_id
VARCHAR(10) support_type
 VARCHAR(10) query
VARCHAR(10) response
ENUM status

BOOKINF_SECTION SE
VARCHAR(10)Autoincrement service_id
varchar(20) service_name
VARCHAR(60) description
VARCHAR(15)
DATE
VARCHAR(50)
DECIMAL(10,2)

BOKKING_SERVICES BOOKING_
VARCHAR(10) booking_id
VARCHAR(10) service_id
user_id
name
email
phone
password_hash

play_id
title
location
play_date
play_time
available_seats

CO
corporate_offer_id
company_name
offer_details
validity_date
 SUB_CATEGORIES

PK VARCHAR(10)Autoincrement
FK VARCHAR(10)
VARCHAR(20)

MOST_BOOKED_SERVICES
PK VARCHAR(10)Autoincrement
FK VARCHAR(10)
VARCHAR(20)

CART
PK VARCHAR(10)Autoincrement
FK VARCHAR(10)
FK VARCHAR(10)
DECIMAL(10,2)
VARCHAR(50)

CE_SERVICES
VARCHAR(10)Autoincrement
varchar(20)
KING
VARCHAR(10)Autoincrement
VARCHAR(20)
VARCHAR(20)
VARCHAR(100)
DATETIME
VARCHAR(50)
ENUM

STAY_BOOKINGS
PK VARCHAR(10)Autoincrement
FK VARCHAR(10)
FK VARCHAR(10)
DATE
DATE
INT
INT
DECIMAL(10,2)
FK VARCHAR(10)
ENUM

CAR_RENTALS
PK VARCHAR(10)Autoincrement
FK ENUM
FK VARCHAR(10)
DECIMAL(10,2)
VARCHAR(50)
FLOAT
ENUM
DECIMAL(10,2)
 CURRENCIES
PK VARCHAR(10)Autoincrement
VARCHAR(10)
VARCHAR(20)

RIDE_BOOKING
PK VARCHAR(10)Autoincrement
FK VARCHAR(10)
VARCHAR(100)
VARCHAR(100)
TIMESTAMP
ENUM
DATE
DECIMAL(10,2)
FK VARCHAR(10)
FK VARCHAR(10)

RIDE_FARES
PK VARCHAR(10)Autoincrement
FK VARCHAR(10)
FK DECIMAL(10,2)
DECIMAL(10,2)
DECIMAL(10,2)
ENUM

CUSTOMER_SUPPORT
PK VARCHAR(10)Autoincrement
FK VARCHAR(10)
ENUM
 VARCHAR(100)
VARCHAR(100)
ENUM

SERVICE_OVERVIEW
PK VARCHAR(10)Autoincrement
VARCHAR(20)
VARCHAR(100)

BOOKING_VALUE_ADDED_SERVICES
FK VARCHAR(10)
FK VARCHAR(10)
 USER
PK VARCHAR(10)Autoincrement
varchar(20)
VARCHAR(60)
VARCHAR(15)
VARCHAR(100)

PLAYS
PK VARCHAR(10)Autoincrement
VARCHAR(20)
VARCHAR(50)
DATE
TIME
INT

CORPORATE_OFFERS
PK VARCHAR(10)Autoincrement
FK VARCHAR(20)
FK VARCHAR(100)
DATE
 SERVICES
service_id
subcategory_id
service_name
rating
desc
image

PACKAGE_SERVICE
package_id
package_name
subcategory_id

CART_ITEM
cart_item_id
cart_id
service_id
quantity
price

SERVICE_SELECTION
subcatservice_selection_idegory_id PK
category
 CART
cart_id PK
user_id FK
selected_package_id FK
total_price
discount_code
option_id FK

FIGHTS
flight_id
airline
flight_number
departure_city
arrival_city
departure_time
arrival_time
stops
price
baggage_info
fare_rules
flight_type

CAR_RENTAL_BOOKINGS
booking_id
user_id
rental_id
pickup_location
dropoff_location
start_date
end_date
price
payment_id
status
 PAYMENT
payment_id
user_id
payment_method
payment_status
transaction_id

RENTALS
rental_id
user_id
vehicle_id
rental_duration
rental_price
rental_status

RIDE_INSURANCE
ride_insurance_id
ride_id
insurance_price
insurance_provider

VALUE_ADDED_SERVICES
service_id
service_name
details

BOOKING_OTHER_SERVICES
booking_id
service_id

CUSTOMER_TESTIMONIALS
customer_test_id
user_id
rating
video_url
review
booking_id
 MOVIES
movie_id
title
genre
language
duration
release_date
status

SPORT_EVENTS
sport_event_id
title
sport_type
location
event_date
event_time
available_seats

GIFT_CARDS
gift_card_id
user_id
card_code
amount
expiry_date
 PERSONAL CARE SERV

SERVICES
PK VARCHAR(10)Autoincrement
FK VARCHAR(10)
VARCHAR(20)
FLOAT
VARCHAR(100)
BLOB

PACKAGE_SERVICE
PK VARCHAR(10)Autoincrement
VARCHAR(20)
FK VARCHAR(10)

CART_ITEM
PK VARCHAR(10)Autoincrement
FK VARCHAR(10)
FK VARCHAR(10)
INT
DECIMAL(!0,2)

TION
VARCHAR(10)Autoincrement
VARCHAR(10)
VARCHAR(10)Autoincrement
VARCHAR(10)
VARCHAR(10)
DECIMAL(10,2)
VARCHAR(50)
VARCHAR(10)

TRAVEL AND BOOKING S

FIGHTS
PK VARCHAR(10)Autoincrement
FK VARCHAR(50)
VARCHAR(50)
VARCHAR(50)
VARCHAR(50)
DATETIME
DATETIME
ENUM
DECIMAL(10,2)
VARCHAR(100)
VARCHAR(100)
ENUM

CAR_RENTAL_BOOKINGS
PK VARCHAR(10)Autoincrement
FK VARCHAR(10)
VARCHAR(10)
VARCHAR(100)
VARCHAR(100)
DATETIME
DATETIME
DECIMAL(10,2)
FK VARCHAR(10,2)
ENUM
 PAYMENT
PK VARCHAR(10)Autoincrement
FK VARCHAR(10)
ENUM
ENUM
VARCHAR(50)

INTERCITY

RENTALS
PK VARCHAR(10)Autoincrement
FK VARCHAR(10)
FK VARCHAR(10)
INT
DECIMAL(10,2)
ENUM

RIDE_INSURANCE
PK VARCHAR(10)Autoincrement
FK VARCHAR(10)
DECIMAL(10,2)
 VARCHAR(100)

HOME SHIFTING

VALUE_ADDED_SERVICES
PK VARCHAR(10)Autoincrement
FK VARCHAR(20)
VARCHAR(100)

BOOKING_OTHER_SERVICES
FK VARCHAR(10)
FK VARCHAR(10)

CUSTOMER_TESTIMONIALS
PK VARCHAR(10)Autoincrement
FK VARCHAR(10)
FLOAT
VARCHAR(100)
VARCHAR(100)
VARCHAR(10)
 MOVIES
PK VARCHAR(10)Autoincrement
VARCHAR(20)
VARCHAR(100)
VARCHAR(100)
INT
DATE
ENUM

SPORT_EVENTS
PK VARCHAR(10)Autoincrement
VARCHAR(20)
VARCHAR(50)
VARCHAR(50)
DATE
TIME
INT

GIFT_CARDS
PK VARCHAR(10)Autoincrement
FK VARCHAR(10)
VARCHAR(50)
DECIMAL(10,2)
DATE
 PERSONAL CARE SERVICES

PAYMENT
payment_id PK
cart_id FK
payment_method
payment_status
transaction_id

USER
user_id PK
name
email
phone
password_hash

HOUSE AND OFFICE SERVICES

SERVICES
service_id PK VARCHAR(10)Autoincrement
service_selection_id FK VARCHAR(10)
service_name VARCHAR(20)
rating FLOAT
desc VARCHAR(100)
image BLOB
price DECIMAL

PAYMENT
payment_id PK VARCHAR(10)Autoincrement
cart_id FK VARCHAR(10)
payment_method VARCHAR(50)
payment_status ENUM
transaction_id VARCHAR(50)
user_id FK VARCHAR(10)

TRAVEL AND BOOKING SYSTEM

PRICE_ALERTS
price_alert_id PK
user_id FK
flight_id FK
alert_price

TAXIS
taxi_id PK
driver_name
vehicle_type
price_per_km
 CART
cart_id PK
user_id FK
item_type
item_id
quantity

INTERCITY

VEHICLES
vehicle_id PK
vehicle_type
price_per_km
availability_status

PAYMENTS
payment_id PK
user_id FK
ride_id FK
rental_id FK
payment_method
payment_status
transaction_id
amount

PAYMENT_HISTORY
history_id PK
 payment_id FK
receipt_url

HOME SHIFTING

OTHER_SERVICES
service_id PK
service_name FK
details

VALUE_ADDED_SERVICES
value_added_service_id PK
service_name
details

MOVIE AND EVENT BOOKING SYSTEM

SHOW_TIME
show_time_id PK
movie_id FK
theater_name
location
show_date
show_time
available_seats

ACTIVITIES
activity_id PK
title
activity_type
location
activity_date
activity_time
T
VARCHAR(10)Autoincrement
VARCHAR(10)
VARCHAR(50)
ENUM
VARCHAR(50)

VARCHAR(10)Autoincrement
varchar(20)
VARCHAR(60)
VARCHAR(15)
VARCHAR(100)

SERVICE_CATEGORIES
category_id PK
service_id FK
category_name
 RATING
rating_id PK
user_id FK
service_id FK
rating
review

TS USE
VARCHAR(10)Autoincrement user_id
VARCHAR(10) name
VARCHAR(10) email
DECIMAL(10,2) phone
password_hash

TAXI_BO
VARCHAR(10)Autoincrement booking_id
VARCHAR(50) user_id
ENUM taxi_id
DECIMAL(10,2) pickup_location
dropoff_location
estimated_price
payment_id
status
 CUSTOMER
VARCHAR(10)Autoincrement customer_service_id
VARCHAR(10) support_type
ENUM faq
INT contact_details
INT

RIDE_VE
VARCHAR(10)Autoincrement ride_vehicle_id
ENUM ride_id
DECIMAL(10,2) vehicle_id
ENUM

S COUPO
VARCHAR(10)Autoincrement cupons_id
VARCHAR(10) coupon_code
VARCHAR(10) discount_percentage
VARCHAR(10) expiry_date
ENUM
ENUM
VARCHAR(100)
DECIMAL(10,2)

TORY
VARCHAR(10)Autoincrement
 VARCHAR(10)
VARCHAR(100)

ICES
VARCHAR(10)Autoincrement
VARCHAR(20)
VARCHAR(100)

ERVICES
VARCHAR(10)Autoincrement
VARCHAR(20)
VARCHAR(100)

M
M

ME STREM
VARCHAR(10)Autoincrement streming_id
VARCHAR(10) title
VARCHAR(50) genre
VARCHAR(50) language
DATE release_date
TIME type
INT

S BOOKI
VARCHAR(10)Autoincrement booking_id
VARCHAR(20) user_id
ENUM type
VARCHAR(50) reference_id
DATE seats_booked
TIME total_price
booking_status
ICE_CATEGORIES
VARCHAR(10)Autoincrement user_id
VARCHAR(10) name
VARCHAR(30) email
phone
password_hash
RATING
VARCHAR(10)Autoincrement
VARCHAR(10) SE
VARCHAR(10) option_id
INT service_id
VARCHAR(100) option_name
price

USER
PK VARCHAR(10)Autoincrement
varchar(20)
VARCHAR(60)
VARCHAR(15)
VARCHAR(100)

TAXI_BOOKING
PK VARCHAR(10)Autoincrement
VARCHAR(10)
VARCHAR(10)
VARCHAR(100)
VARCHAR(100)
DECIMAL(!0,2)
FK VARCHAR(10)
ENUM
 CUSTOMER_SERVICE
PK VARCHAR(10)Autoincrement
ENUM
VARCHAR(50)
VARCHAR(50)

RIDE_VEHICLE
PK VARCHAR(10)Autoincrement
FK VARCHAR(10)
FK VARCHAR(10)

COUPONS
PK VARCHAR(10)Autoincrement
VARCHAR(50)
DECIMAL(10,2)
DATE
 STREMING
PK VARCHAR(10)Autoincrement
VARCHAR(20)
VARCHAR(100)
VARCHAR(40)
DATE
ENUM

BOOKINGS
PK VARCHAR(10)Autoincrement
FK VARCHAR(10)
ENUM
INT
INT
DECIMAL(10,2)
ENUM
 USER
PK VARCHAR(10)Autoincrement
varchar(20)
VARCHAR(60)
VARCHAR(15)
VARCHAR(100)
 SERVICE_OPTIONS
PK VARCHAR(10)Autoincrement
FK VARCHAR(10)
VARCHAR(30)
DECIMAL(10,2)

ATTRACTIONS
attractin_id PK
attraction_name
location
category
event_time
price

ATTRACTION_BOOKINGS
booking_id PK
user_id FK
attraction_id FK
adults
children
price
payment_id FK
status
 PAYMENTS
payment_id PK
user_id FK
payment_method
amount
status
payment_date
 EVENTS
event_id PK
title
event_type
location
event_date
event_time
available_seats

OFFERS
offer_id PK
offer_name
discount_percentage
expiry_date
category_id FK
ONS
VARCHAR(10)Autoincrement
VARCHAR(10)
VARCHAR(50)
ENUM
TIME
DECIMAL(10,2)

OOKINGS COUPONS
VARCHAR(10)Autoincrement coupon_id PK
VARCHAR(10) coupon_code FK
VARCHAR(10) discount_percent
INT expiry_date
INT
DECIMAL(10,2)
VARCHAR(10)
ENUM
TS PRICE_ALERTS
VARCHAR(10)Autoincrement alert_id PK
VARCHAR(10) user_id FK
ENUM flight_id FK
DECIMAL(10,2) target_price
ENUM alert_status
DATE
S
VARCHAR(10)Autoincrement
VARCHAR(20)
ENUM
VARCHAR(40)
DATE
TIME
INT

S
VARCHAR(10)Autoincrement
VARCHAR(30)
DECIMAL(10,2)
DATE
VARCHAR(10)
 COUPONS
VARCHAR(10)Autoincrement
VARCHAR(50)
DECIMAL(5,2)
DATE
PRICE_ALERTS
VARCHAR(10)Autoincrement
VARCHAR(10)
VARCHAR(10)
DECIMAL(10,2)
ENUM