Primary

Table Name Table ID Entity Name Entity ID Key

SERVICE_SELECTION service_selection_id ✅

category_id -

Primary
Table Name Table ID Entity Name Entity ID Key

CATEGORY category_id ✅
category_name -

Primary
Table Name Table ID Entity Name Entity ID Key

USERS user_id ✅
username -

email -

Primary
Table Name Table ID Entity Name Entity ID Key

USERS user_id ✅
username -

email -

Primary
Table Name Table ID Entity Name Entity ID Key

SCHEDULE_APPOINTMENT schedule_app_id ✅
user_id -
selected_package_id -
address -
time_slot -
payment_method -

Primary
Table Name Table ID Entity Name Entity ID Key
payment_id
PAYMENT ✅
 schedule_app_id -
payment_method -
payment_status -

Primary
Table Name Table ID Entity Name Entity ID Key

SUB_CATEGORIES subcategory_id ✅
category_id -
subcategory_name -
-

Primary
Table Name Table ID Entity Name Entity ID Key

Most Booked Services most_booked_service_id ✅

browser_service_id -
service_name -
-

Primary
Table Name Table ID Entity Name Entity ID Key

CART cart_id ✅
user_id -

total_price -
discount_code

Primary
Table Name Table ID Entity Name Entity ID Key

selected_package_id
SERVICE_SELECTION ✅
cart_id -

Primary
Table Name Table ID Entity Name Entity ID Key

CART_OPTIONS option_id ✅
cart_id -

Primary
Table Name Table ID Entity Name Entity ID Key

SERVICES service_id ✅
subcategory_id -
 service_name -
rating -
desc -
image -

Primary
Table Name Table ID Entity Name Entity ID Key

CART_OPTIONS package_id ✅
package_name -
subcategory_id -

Primary
Table Name Table ID Entity Name Entity ID Key

CART_ITEM cart_item_id ✅

cart_id -
service_id -

quantity
price

Primary
Table Name Table ID Entity Name Entity ID Key

HOME_OFFICE_SERVICES home_service_id ✅
service_name -

Primary
Table Name Table ID Entity Name Entity ID Key

HOME_OFFICE_SERVICES rating_id ✅
user_id -

service_id -
rating -
review -

Primary
Table Name Table ID Entity Name Entity ID Key

HOME_OFFICE_SERVICES booking_id ✅
user_id -
 time_slot -
address_id -
payment_id -
status_id

Primary
Table Name Table ID Entity Name Entity ID Key

ADDRESS address_id ✅
user_id -
address -

Primary
Table Name Table ID Entity Name Entity ID Key

STATUS status_id ✅
status

Primary
Table Name Table ID Entity Name Entity ID Key

STAYS stay_id ✅
stay_name
 location_id
category_id
price
rating
total_rooms
available_id

Primary
Table Name Table ID Entity Name Entity ID Key

LOCATION location_id ✅
location_name

Primary
Table Name Table ID Entity Name Entity ID Key

AVAILABILITY available_id ✅
available

Primary
Table Name Table ID Entity Name Entity ID Key

FLIGHT_HOTEL_PACKAGES flight_hotel_package_id ✅
departure_airport_id
date_time_id
travellers
flight_class_id
package_price
destination_id

Primary
Table Name Table ID Entity Name Entity ID Key

AIRPORTS airport_id ✅
airport_name
location

Primary
Table Name Table ID Entity Name Entity ID Key
DATE_TIME date_time_id ✅
departure_time

Primary
Table Name Table ID Entity Name Entity ID Key
FLIGHT_CLASS class_id ✅
class_name

Primary
Table Name Table ID Entity Name Entity ID Key

DESTINATIONS destination_id ✅
destination_name

Primary
Table Name Table ID Entity Name Entity ID Key

PROPERTIES property_id ✅
owner_id

Primary
Table Name Table ID Entity Name Entity ID Key

PROPERTY_DETAILS property_id
property_name
address
price_per_night

Primary
Table Name Table ID Entity Name Entity ID Key

PROPERTY_FACILITIES property_id
facilities

Primary
Table Name Table ID Entity Name Entity ID Key

OWNERS owner_id

Primary
Table Name Table ID Entity Name Entity ID Key

BOOKINGS booking_id
user_id
stay_id
checkin_date
checkout_date
payment_id
 Primary
Table Name Table ID Entity Name Entity ID Key

BOOKING_GUESTS booking_id
adults
children

Primary
Table Name Table ID Entity Name Entity ID Key

BOOKING_PRICING booking_id
total_price

Primary
Table Name Table ID Entity Name Entity ID Key

BOOKING_STATUS booking_id
status

Primary
Table Name Table ID Entity Name Entity ID Key
CAR_RENTALS car_rent_id ✅
car_type_id
pickup_location_id
rental_price
rental_company_id
rating
availability_id
price_per_day

Primary
Table Name Table ID Entity Name Entity ID Key

CAR_TYPES car_type_id ✅
car_type

Primary
Table Name Table ID Entity Name Entity ID Key

RENTAL_COMPANIES rental_company_id ✅
rental_company

Primary
Table Name Table ID Entity Name Entity ID Key

CURRENCIES currencies_id ✅
 currency_code
currency_name

Primary
Table Name Table ID Entity Name Entity ID Key

FLIGHTS flight_id ✅
flight_number
airline_id
flight_type

Primary
Table Name Table ID Entity Name Entity ID Key

FLIGHT_SCHEDULE schedule_id ✅
flight_id
departure_id
arrival_id
departure_time
arrival_time

Primary
Table Name Table ID Entity Name Entity ID Key

FLIGHT_PRICING pricing_id ✅
flight_id
price
stops
baggage_id
fare_rules_id

Primary
Table Name Table ID Entity Name Entity ID Key

CAR_RENTAL_LOCATIONS rental_location_id ✅
car_rent_id
pickup_location_id
availability_id

Primary
Table Name Table ID Entity Name Entity ID Key

CAR_RENTAL_LOCATIONS rental_location_id ✅
car_rent_id
rental_price
rating
 Primary
Table Name Table ID Entity Name Entity ID Key

BAGGAGE_INFO baggage_id ✅
details

Primary
Table Name Table ID Entity Name Entity ID Key

FARE_RULES fare_rules_id ✅
details

Primary
Table Name Table ID Entity Name Entity ID Key

Car_Rental_Bookings booking_id ✅
user_id
rental_id
payment_id

Primary
Table Name Table ID Entity Name Entity ID Key

Booking_Location booking_id ✅
pickup_location
dropoff_location

Primary
Table Name Table ID Entity Name Entity ID Key

Booking_Duration booking_id ✅
start_date
end_date

Primary
Table Name Table ID Entity Name Entity ID Key

Booking_Payment payment_id ✅
price

Primary
Table Name Table ID Entity Name Entity ID Key

Payment payment_id ✅
user_id
transaction_id
cart_id
 payment_date
amount

Primary
Table Name Table ID Entity Name Entity ID Key

Payment_Method method_id ✅
method_name

Primary
Table Name Table ID Entity Name Entity ID Key

Payment_Status status_id ✅
status_name

Primary
Table Name Table ID Entity Name Entity ID Key

Payment_Transactions payment_id ✅
method_id
status_id

Primary
Table Name Table ID Entity Name Entity ID Key

PRICE_ALERTS price_alert_id ✅
user_id
flight_id
alert_price

Primary
Table Name Table ID Entity Name Entity ID Key

TAXIS taxi_id ✅
driver_name
vehicle_type
price_per_km

Primary
Table Name Table ID Entity Name Entity ID Key

CART_T cart_id ✅
user_id
item_type
item_id
quantity
 Primary
Table Name Table ID Entity Name Entity ID Key

Taxis taxi_id ✅
driver_name
vehicle_type
price_per_km

Primary
Table Name Table ID Entity Name Entity ID Key

Taxi_Booking booking_id ✅
user_id
taxi_id
pickup_location
dropoff_location
estimated_price
payment_id
status

Primary
Table Name Table ID Entity Name Entity ID Key

CUSTOMER_SERVICE customer_service_id ✅
support_type
faq
contact_details

Primary
Table Name Table ID Entity Name Entity ID Key

Attractions attraction_id ✅
attraction_name

location_id
category_id

Primary
Table Name Table ID Entity Name Entity ID Key
Categories category_id ✅
category_name

Primary
Table Name Table ID Entity Name Entity ID Key

Events event_id ✅
attraction_id
event_time
price

Primary
Table Name Table ID Entity Name Entity ID Key
ATTRACTION_BOOKINGS booking_id ✅
user_id
attraction_id
price
payment_id
status

Primary
Table Name Table ID Entity Name Entity ID Key

Visitor booking_id ✅
adults
children

Primary
Table Name Table ID Entity Name Entity ID Key

Coupons coupon_id ✅
coupon_code
discount_percent
expiry_date

Primary
Table Name Table ID Entity Name Entity ID Key
Driver Information driver_id ✅
name
phone

Primary
Table Name Table ID Entity Name Entity ID Key

Driver Ratings driver_id

rating

Primary
Table Name Table ID Entity Name Entity ID Key

Driver License driver_id

license_no

Primary
Table Name Table ID Entity Name Entity ID Key

Driver Vehicle driver_id

vehicle_id

Primary
Table Name Table ID Entity Name Entity ID Key

Ride Booking ride_booking_id ✅

user_id
driver_id
booking_time
ride_status

Primary
Table Name Table ID Entity Name Entity ID Key
Ride Location ride_booking_id
pickup_location
drop_location

Primary
Table Name Table ID Entity Name Entity ID Key
Ride Schedule ride_booking_id
schedule_date

Primary
Table Name Table ID Entity Name Entity ID Key
Ride Payment ride_booking_id
payment_id
price

Primary
Table Name Table ID Entity Name Entity ID Key

Ride Fares ride_fare_id ✅

ride_id
status

Primary
Table Name Table ID Entity Name Entity ID Key

Base Fare base_fare_id ✅

base_fare

Primary
Table Name Table ID Entity Name Entity ID Key

Ride Offers ride_fare_id

user_offer

Primary
Table Name Table ID Entity Name Entity ID Key

Final Fare Calculation ride_fare_id

final_fare

Primary
Table Name Table ID Entity Name Entity ID Key
CUSTOMER_SUPPORT customer_support_id ✅
user_id
support_type
query
response
status

Primary
Table Name Table ID Entity Name Entity ID Key

BOOKING booking_id ✅
user_id
booking_status
 Primary
Table Name Table ID Entity Name Entity ID Key

BOOKING_RIDE booking_id
ride_id

Primary
Table Name Table ID Entity Name Entity ID Key

BOOKING_RENTAL booking_id
rental_id

Primary
Table Name Table ID Entity Name Entity ID Key

RENTALS rental_id ✅
user_id
rental_status

Primary
Table Name Table ID Entity Name Entity ID Key

RENTAL_DETAILS rental_id
vehicle_id
rental_duration
rental_price

Primary
Table Name Table ID Entity Name Entity ID Key

RIDE_INSURANCE ride_insurance_id ✅
ride_id

insurance_price
insurance_provider

Primary
Table Name Table ID Entity Name Entity ID Key

VEHICLES vehicle_id ✅
vehicle_type
price_per_km
availability_status

Primary
Table Name Table ID Entity Name Entity ID Key
PAYMENT_S payment_id ✅
user_id
ride_id
rental_id

Primary
Table Name Table ID Entity Name Entity ID Key

PAYMENT_HISTORY history_id ✅
payment_id
receipt_url

Primary
Table Name Table ID Entity Name Entity ID Key

PAYMENT_HISTORY ride_vehicle_id ✅
ride_id
vehicle_id

Primary
Table Name Table ID Entity Name Entity ID Key

BOOKING_SECTION booking_id ✅
shifting_date
time_slot
price

Primary
Table Name Table ID Entity Name Entity ID Key

BOOKING_SECTION contact_id ✅
booking_id
phone_number
 Primary
Table Name Table ID Entity Name Entity ID Key
BOOKING_SERVICES booking_id
service_id

Primary
Table Name Table ID Entity Name Entity ID Key

SERVICE_OVERVIEW service_id ✅
service_name
description

Primary
Table Name Table ID Entity Name Entity ID Key

BOOKING_VALUE_ADDED_SERVICES booking_id
service_id

Primary
Table Name Table ID Entity Name Entity ID Key

VALUE_ADDED_SERVICES service_id ✅
service_name
details

Primary
Table Name Table ID Entity Name Entity ID Key

BOOKING_OTHER_SERVICES booking_id
service_id

Primary
Table Name Table ID Entity Name Entity ID Key

OTHER_SERVICES service_id
service_name
details

Primary
Table Name Table ID Entity Name Entity ID Key

VALUE_ADDED_SERVICES value_added_service_id ✅
service_name
details
 Primary
Table Name Table ID Entity Name Entity ID Key

TESTIMONIALS customer_test_id ✅
user_id
rating
booking_id

Primary
Table Name Table ID Entity Name Entity ID Key

TESTIMONIALS customer_test_id ✅
user_id
rating
booking_id

Primary
Table Name Table ID Entity Name Entity ID Key

TESTIMONIAL_DETAILS customer_test_id
video_url

review

Primary
Table Name Table ID Entity Name Entity ID Key
PLAYS play_id ✅
title
location

Primary
Table Name Table ID Entity Name Entity ID Key
PLAY_SCHEDULE schedule_id ✅
play_id
play_date
play_time
available_seats

Primary
Table Name Table ID Entity Name Entity ID Key
CORPORATE_OFFERS corporate_offer_id ✅
 company_name

offer_details
validity_date

Primary
Table Name Table ID Entity Name Entity ID Key
MOVIES movie_id ✅
title

release_date
status

Primary
Table Name Table ID Entity Name Entity ID Key
MOVIE_DETAILS movie_id
genre
language
duration

Primary
Table Name Table ID Entity Name Entity ID Key

SPORT_EVENTS sport_event_id ✅
title
sport_type
location

Primary
Table Name Table ID Entity Name Entity ID Key
EVENT_SCHEDULE sport_event_id
event_date

event_time
available_seats

Primary
Table Name Table ID Entity Name Entity ID Key
GIFT_CARDS gift_card_id ✅
user_id
card_code

Primary
Table Name Table ID Entity Name Entity ID Key
GIFT_CARD_DETAILS gift_card_id
amount
 expiry_date

Primary
Table Name Table ID Entity Name Entity ID Key

SHOW_TIME show_time_id ✅
movie_id
theater_id
show_date
show_time

Primary
Table Name Table ID Entity Name Entity ID Key

THEATER theater_id ✅
theater_name
location

Primary
Table Name Table ID Entity Name Entity ID Key
SHOW_SEATS show_time_id
available_seats
 PERSONAL CARE SERVICES

Foreign Key

✅ (CATEGORY, category_id)

Foreign Key

-
-

Foreign Key

-
-

Foreign Key

-
-

Foreign Key

-
✅ (USERS, user_id)
✅ (SERVICE_SELECTION, service_selection_id)
-
-
-

Foreign Key

-
✅ (SCHEDULE_APPOINTMENT, schedule_app_id)
-
-

Foreign Key

-
✅ (CATEGORY, category_id)
-
-

Foreign Key

-
✅ (SERVICES, service_id)
-
-

Foreign Key

-
✅ (USERS, user_id)

-
-

Foreign Key

-
✅ (CART, cart_id)

Foreign Key

-
✅ (CART, cart_id)

Foreign Key

-
✅ (SUB_CATEGORIES, subcategory_id)
-
-
-
-

Foreign Key

-
-
✅ (SUB_CATEGORIES, subcategory_id)

Foreign Key

✅ (CART, cart_id)
✅ (SERVICES, service_id)

HOUSE AND OFFICE SERVICES

Foreign Key

-
-

Foreign Key

-
✅ (USERS, user_id)

✅ (SERVICES, service_id)
-
-

Foreign Key

-
✅ (USERS, user_id)
✅ (SERVICES, service_id)
✅ (SERVICES, service_id)
✅ (SERVICES, service_id)

Foreign Key

-
✅ (USERS, user_id)
-

Foreign Key

SERVICE_SELECTION

CART

SERVICE

PAYMENT

SERVICE_CATEGORIES

USER

SERVICE_OPTIONS

TRAVEL AND BOOKING SYSTEM

Foreign Key

-
LOCATION(location_id
CATEGORY(category_id)

AVAILABILITY(available_id)

Foreign Key

Foreign Key

Foreign Key

-
✅ (AIRPORTS, airport_id)
✅ (DATE_TIME, date_time_id)

✅ (FLIGHT_CLASS, class_id)

✅ (DESTINATIONS, destination_id)

Foreign Key

Foreign Key
-

Foreign Key
-

Foreign Key

Foreign Key

-
✅ (OWNERS, owner_id)

Foreign Key

✅ (PROPERTIES, property_id)

Foreign Key

✅ (PROPERTIES, property_id)

Foreign Key

Foreign Key

✅ (USERS, user_id)
✅ (PROPERTIES, property_id)

✅ (PAYMENTS, payment_id)
Foreign Key

✅ (BOOKINGS, booking_id)

Foreign Key

✅ (BOOKINGS, booking_id)

Foreign Key

✅ (BOOKINGS, booking_id)

Foreign Key

FOREIGN KEY (CAR_TYPES)

FOREIGN KEY (LOCATIONS)

FOREIGN KEY (RENTAL_COMPANIES)

AVAILABILITY(available_id)

Foreign Key

Foreign Key

Foreign Key
Foreign Key

(AIRLINES,airline_id)

Foreign Key

(FLIGHTS.flight_id)
(CITIES.departure_id)
(CITIES.arrival_id)

Foreign Key

(FLIGHTS.flight_id)
(CITIES.departure_id)

(BAGGAGE_INFO.baggage_id)
(FARE_RULES.fare_rules_id)

Foreign Key

(CAR_RENTALS.car_rent_id)
(LOCATIONS.pickup_location_id)
(AVAILABILITY.availability_id)

Foreign Key

(CAR_RENTALS.car_rent_id)
Foreign Key

Foreign Key

Foreign Key

Users(user_id)
Cars(rental_id)
Payments(payment_id)

Foreign Key

Car_Rental_Bookings(booking_id)

Foreign Key

Car_Rental_Bookings(booking_id)

Foreign Key

Foreign Key

Users(user_id)
Cart(cart_id)
Foreign Key

Foreign Key

Foreign Key

Payment(payment_id).
Payment_Method(method_id)
Payment_Status(status_id)

Foreign Key

Users(user_id)
Flights(flight_id)

Foreign Key

Foreign Key

Users(user_id)
 USER

PAYMENTS

Foreign Key

Foreign Key

Users(user_id)
Taxis(taxi_id)

Payments(payment_id)

Foreign Key

Foreign Key

Locations(location_id)
Categories(category_id)

Foreign Key
Foreign Key

Attractions(attraction_id)

Foreign Key

Users(user_id)
Attractions(attraction_id)

Foreign Key

Foreign Key

PRICE_ALERTS

TRAVEL AND BOOKING SYSTEM

USER

Foreign Key
Foreign Key

Driver Information(driver_id),

Foreign Key

Driver Information(driver_id),

Foreign Key

Driver Information(driver_id),

Foreign Key

Users(user_id)
Drivers(driver_id)

Foreign Key
Ride_Booking(ride_booking_id)

Foreign Key
Ride_Booking(ride_booking_id)

Foreign Key
Ride_Booking(ride_booking_id)
Payments(payment_id)

Foreign Key

Rides(ride_id)

Foreign Key

Foreign Key

Ride_Fares(ride_fare_id)

Foreign Key

Ride_Fares(ride_fare_id)

Foreign Key

Users(user_id)

Foreign Key

(Users.user_id)
Foreign Key

(BOOKING.booking_id)
(RIDES.ride_id)

Foreign Key

(BOOKING.booking_id)
(RENTALS.rental_id)

Foreign Key

(Users.user_id)

Foreign Key

(RENTALS.rental_id)
(VEHICLES.vehicle_id)

Foreign Key

(RIDES.ride_id)

Foreign Key

Foreign Key
USERS(user_id)
RIDES(ride_id)
RENTALS(rental_id)

Foreign Key

PAYMENT_S(payment_id)

Foreign Key

RIDE_TABLE(ride_id)
VEHICLE(vehicle_id)

COUPONS

TRAVEL AND BOOKING SYSTEM

Foreign Key

Foreign Key

BOOKING(booking_id)

BOOKING_LOCATION
Foreign Key
BOOKING(booking_id)
BOOKING(booking_id)

Foreign Key

Foreign Key

(BOOKING_SECTION.booking_id)
(SERVICES.service_id)

Foreign Key

(SERVICES.service_id)

Foreign Key

(BOOKINGS.booking_id)
(SERVICES.service_id)

Foreign Key

(BOOKING_OTHER_SERVICES.service_id)

Foreign Key
Foreign Key

Foreign Key

USER (user_id)

BOOKINGS (booking_id)

Foreign Key

(TESTIMONIALS.customer_test_id)

MOVIE AND EVENT BOOKING SYSTE

USER

Foreign Key

Foreign Key

PLAYS(play_id)

Foreign Key
COMPANIES(company_name)

OFFERS(offer_details)

Foreign Key

Foreign Key
MOVIES(movie_id)

Foreign Key

Foreign Key
SPORT_EVENTS(sport_event_id)

Foreign Key

USERS(user_id)

Foreign Key
GIFT_CARDS(gift_card_id)
Foreign Key

MOVIE(movie_id)
THEATER(theater_id)

Foreign Key

Foreign Key
SHOW_TIME(show_time_id)
 PERSONAL CARE SERVICES

Data Type

VARCHAR(10)

VARCHAR(10)

Data Type

VARCHAR(10)
VARCHAR(20)

Data Type

VARCHAR(10)
VARCHAR(30)

VARCHAR(50)

Data Type

VARCHAR(10)
VARCHAR(30)

VARCHAR(50)

Data Type

VARCHAR(10)
VARCHAR(10)
VARCHAR(10)
VARCHAR(100)
DATETIME
VARCHAR(10)

Data Type

VARCHAR(10)
VARCHAR(10)
VARCHAR(10)
VARCHAR(15)

Data Type

VARCHAR(10)
VARCHAR(10)
VARCHAR(20)

Data Type

VARCHAR(10)
VARCHAR(10)
VARCHAR(20)

Data Type

VARCHAR(10)
VARCHAR(10)

DECIMAL(10,2)
VARCHAR(50)

Data Type

VARCHAR(10)
VARCHAR(10)

Data Type

VARCHAR(10)
VARCHAR(10)

Data Type

VARCHAR(10)
VARCHAR(10)
VARCHAR(20)
FLOAT
VARCHAR(100)
BLOB

Data Type

VARCHAR(10)
VARCHAR(20)
VARCHAR(10)

Data Type

VARCHAR(10)

VARCHAR(10)
VARCHAR(10)

INT
DECIMAL(10,2)

HOUSE AND OFFICE SERVICES

Data Type

VARCHAR(10)
varchar(20)

Data Type

VARCHAR(10)
VARCHAR(10)

VARCHAR(10)
INT
VARCHAR(100)

Data Type

VARCHAR(10)
VARCHAR(10)
DATETIME
VARCHAR(10)
VARCHAR(10)
VARCHAR(10)

Data Type

VARCHAR(10)
VARCHAR(20)
VARCHAR(100)

Data Type

VARCHAR(10)
ENUM

SERVICE_SELECTION

CART

SERVICE

PAYMENT

SERVICE_CATEGORIES

USER

SERVICE_OPTIONS

TRAVEL AND BOOKING SYSTEM

Data Type

VARCHAR(10)
VARCHAR(20)
VARCHAR(10)
VARCHAR(10)
DECIMAL(10,2)
FLOAT
INT
VARCHAR(10)

Data Type

VARCHAR(10)
VARCHAR(60)

Data Type

VARCHAR(10)
BOOLEAN

Data Type

VARCHAR(10)
VARCHAR(10)
VARCHAR(10)
INT
VARCHAR(10)
DECIMAL(10,2)
VARCHAR(10)

Data Type

VARCHAR(10)
VARCHAR(50)
VARCHAR(50)

Data Type
VARCHAR(10)
DATETIME

Data Type
VARCHAR(10)
ENUM('Economy', 'Business')

Data Type

VARCHAR(10)
VARCHAR(50)

Data Type

VARCHAR(10)
VARCHAR(10)

Data Type

VARCHAR(10)
VARCHAR(20)
VARCHAR(100)
DECIMAL(10,2)

Data Type

VARCHAR(10)
VARCHAR(100)

Data Type

VARCHAR(10)

Data Type

VARCHAR(10)
VARCHAR(10)
VARCHAR(10)
DATE
DATE
VARCHAR(10)
Data Type

VARCHAR(10)
INT
INT

Data Type

VARCHAR(10)
DECIMAL(10,2)

Data Type

VARCHAR(10)
ENUM('Confirmed', 'Cancelled')

Data Type
VARCHAR(10)
INT
INT
DECIMAL(10,2)
INT
FLOAT
INT
DECIMAL(10,2)

Data Type

VARCHAR(10)
ENUM

Data Type

VARCHAR(10)
VARCHAR(50)

Data Type

VARCHAR(10)
VARCHAR(10)
VARCHAR(20)

Data Type

VARCHAR(10)
VARCHAR(50)
VARCHAR(10)
ENUM('Domestic', 'International')

Data Type

VARCHAR(10)
VARCHAR(10)
VARCHAR(10)
VARCHAR(10)
DATETIME
DATETIME

Data Type

VARCHAR(10)
VARCHAR(10)
DECIMAL(10,2)
ENUM('Direct', '1 Stop', 'Multi-Stop')
VARCHAR(10)
VARCHAR(10)

Data Type

VARCHAR(10)
VARCHAR(10)
VARCHAR(10)
VARCHAR(10)

Data Type

VARCHAR(10)
VARCHAR(10)
DECIMAL(10,2)
FLOAT)
Data Type

VARCHAR(10)
VARCHAR(100)

Data Type

VARCHAR(10)
VARCHAR(100)

Data Type

VARCHAR(10)
VARCHAR(10)
VARCHAR(10)
VARCHAR(10)

Data Type

VARCHAR(10)
VARCHAR(100)
VARCHAR(100)

Data Type

VARCHAR(10)
DATETIME
DATETIME

Data Type

VARCHAR(10)
DECIMAL(10,2)

Data Type

VARCHAR(10)
VARCHAR(10)
VARCHAR(50)
VARCHAR(10)
DATE
DECIMAL(10,2)

Data Type

VARCHAR(10)
VARCHAR(20)

Data Type

VARCHAR(10)
VARCHAR(15)

Data Type

VARCHAR(10)
VARCHAR(10)
VARCHAR(10)

Data Type

VARCHAR(10)
VARCHAR(10)
VARCHAR(10)
DECIMAL(10,2)

Data Type

VARCHAR(10)
VARCHAR(50)
ENUM
DECIMAL(10,2)

Data Type

VARCHAR(10)
VARCHAR(10)
ENUM
INT
INT
 USER

PAYMENTS

Data Type

VARCHAR(10)
VARCHAR(50)
ENUM('Sedan', 'SUV', 'Hatchback')
DECIMAL(10,2)

Data Type

VARCHAR(10)
VARCHAR(10)
VARCHAR(10)
VARCHAR(100)
VARCHAR(100)
DECIMAL(10,2)
VARCHAR(10)
ENUM('Booked', 'In Progress', 'Completed', 'Cancelled')

Data Type

VARCHAR(10)
ENUM
VARCHAR(50)
VARCHAR(50)

Data Type

VARCHAR(10)
VARCHAR(50)

VARCHAR(10)
VARCHAR(10)

Data Type
VARCHAR(10)
VARCHAR(50)

Data Type

VARCHAR(10)
VARCHAR(50)
TIME
DECIMAL(10,2)

Data Type
VARCHAR(10)
VARCHAR(10)
VARCHAR(10)
DECIMAL(10,2)
VARCHAR(10)
ENUM

Data Type

VARCHAR(10)
INT
INT

Data Type

VARCHAR(10)
VARCHAR(50)
DECIMAL(5,2)
DATE

PRICE_ALERTS

TRAVEL AND BOOKING SYSTEM

USER

Data Type
VARCHAR(10)
VARCHAR(20)
VARCHAR(15)

Data Type

VARCHAR(10)
FLOAT

Data Type

VARCHAR(10)

VARCHAR(50)

Data Type

VARCHAR(10)

VARCHAR(10)

Data Type

VARCHAR(10)
VARCHAR(10)
VARCHAR(10)
TIMESTAMP
ENUM

Data Type
VARCHAR(10)
VARCHAR(100)
VARCHAR(100)

Data Type
VARCHAR(10)
DATE

Data Type
VARCHAR(10)
VARCHAR(10)
DECIMAL(10,2)

Data Type

VARCHAR(10)
VARCHAR(10)
ENUM

Data Type

VARCHAR(10)
DECIMAL(10,2)

Data Type

VARCHAR(10)
DECIMAL(10,2)

Data Type

VARCHAR(10)
DECIMAL(10,2)

Data Type
VARCHAR(10)
VARCHAR(10)
ENUM
VARCHAR(100)
VARCHAR(100)
ENUM

Data Type

VARCHAR(10)
VARCHAR(10)
ENUM('Confirmed', 'Cancelled')
Data Type

VARCHAR(10)
VARCHAR(10)

Data Type

VARCHAR(10)
VARCHAR(10)

Data Type

VARCHAR(10)
VARCHAR(10)
ENUM('Pending', 'Active', 'Completed', 'Cancelled')

Data Type

VARCHAR(10)
VARCHAR(10)
INT
DECIMAL(10,2)

Data Type

VARCHAR(10)
VARCHAR(10)

DECIMAL(10,2)
VARCHAR(100)

Data Type

VARCHAR(10)
ENUM('Car', 'Bike', 'Van', 'Bus')
DECIMAL(10,2)
ENUM('Available', 'Booked', 'Under Maintenance')

Data Type
VARCHAR(10)
VARCHAR(10)
VARCHAR(10)
VARCHAR(10)

Data Type

VARCHAR(10)
VARCHAR(10)
VARCHAR(100)

Data Type

VARCHAR(10)
VARCHAR(10)
VARCHAR(10)

COUPONS

TRAVEL AND BOOKING SYSTEM

Data Type

VARCHAR(10)
DATE
VARCHAR(50)
DECIMAL(10,2)

Data Type

VARCHAR(10)
VARCHAR(10)
VARCHAR(15)

BOOKING_LOCATION
Data Type
VARCHAR(10)
VARCHAR(10)

Data Type

VARCHAR(10)
VARCHAR(20)
VARCHAR(100)

Data Type

VARCHAR(10)
VARCHAR(10)

Data Type

VARCHAR(10)
VARCHAR(20)
VARCHAR(100)

Data Type

VARCHAR(10)
VARCHAR(10)

Data Type

VARCHAR(10)
VARCHAR(20)
VARCHAR(100)

Data Type

VARCHAR(10)
VARCHAR(20)
VARCHAR(100)
Data Type

VARCHAR(10)
VARCHAR(10)
FLOAT
VARCHAR(10)

Data Type

VARCHAR(10)
VARCHAR(10)
FLOAT
VARCHAR(10)

Data Type

VARCHAR(10)
VARCHAR(100)

VARCHAR(100)

MOVIE AND EVENT BOOKING SYSTEM

USER

Data Type
VARCHAR(10)
VARCHAR(20)
VARCHAR(50)

Data Type
VARCHAR(10)
VARCHAR(10)
DATE
TIME
INT

Data Type
VARCHAR(10)
VARCHAR(20)

VARCHAR(100)
DATE

Data Type
VARCHAR(10)
VARCHAR(20)

DATE
ENUM('Upcoming', 'Now Showing', 'Archived')

Data Type
VARCHAR(10)
VARCHAR(100)
VARCHAR(100)
INT

Data Type

VARCHAR(10)
VARCHAR(20)
VARCHAR(50)
VARCHAR(50)

Data Type
VARCHAR(10)
DATE

TIME
INT

Data Type
VARCHAR(10)
VARCHAR(10)
VARCHAR(50)

Data Type
VARCHAR(10)
DECIMAL(10,2)
DATE

Data Type

VARCHAR(10)
VARCHAR(10)
VARCHAR(10)
DATE
TIME

Data Type

VARCHAR(10)
VARCHAR(50)
VARCHAR(50)

Data Type
VARCHAR(10)
INT
ES

Constraints

UNIQUE, NOT NULL

NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL

UNIQUE, NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL

UNIQUE, NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL
NOT NULL
NOT NULL
NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL
NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL

NOT NULL
NULLABLE

Constraints

UNIQUE, NOT NULL

NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
 NOT NULL
CHECK (rating BETWEEN 1.0 AND 5.0)
NULLABLE
NULLABLE

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL

NOT NULL
NOT NULL

CES

Constraints

UNIQUE, NOT NULL

NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL

NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
 NOT NULL
NOT NULL
NOT NULL
NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL

Constraints

UNIQUE, NOT NULL

TEM

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL
NOT NULL
CHECK (price >= 0)
CHECK (rating BETWEEN 0 AND 5)
CHECK (total_rooms >= 0)
NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL
NOT NULL
NOT NULL
NOT NULL
NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL

Constraints
UNIQUE, NOT NULL
NOT NULL

Constraints
UNIQUE, NOT NULL
NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL
NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL

Constraints

UNIQUE, NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL
NOT NULL
NOT NULL
NOT NULL
Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL

Constraints
UNIQUE, NOT NULL
NOT NULL
NOT NULL
NOT NULL
NOT NULL
CHECK (rating >= 0 AND rating <= 5)
NOT NULL
PRICE_PER_DAY>0

Constraints

UNIQUE, NOT NULL

NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL
NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL
NOT NULL
NOT NULL
NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL
NOT NULL
NOT NULL
NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL
NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL
CHECK (rating >= 0 AND rating <= 5)
Constraints

UNIQUE, NOT NULL

NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL
NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL
NOT NULL
Constraints

UNIQUE, NOT NULL

NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL
NOT NULL, CHECK (alert_price > 0)

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL
NOT NULL, CHECK (price_per_km > 0)

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL
NOT NULL
NOT NULL, CHECK (quantity > 0)
Constraints

UNIQUE, NOT NULL

NULL allowed
NULL allowed
NOT NULL, CHECK (price_per_km > 0)

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL
NOT NULL
NOT NULL
NOT NULL, CHECK (estimated_price > 0)
NOT NULL
NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL, CHECK (LENGTH(faq) > 5)
NOT NULL, CHECK (LENGTH(contact_details) > 5)

Constraints

UNIQUE, NOT NULL

NOT NULL

UNIQUE, NOT NULL

NOT NULL

Constraints
 UNIQUE, NOT NULL
NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL
NOT NULL

Constraints
UNIQUE, NOT NULL
NOT NULL
NOT NULL
NOT NULL
NOT NULL
NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL

Constraints

UNIQUE, NOT NULL

UNIQUE, NOT NULL
NOT NULL CHECK (discount_percent >= 0 AND discount_percent <= 100)
NOT NULL

TEM

Constraints
UNIQUE, NOT NULL
NOT NULL
NOT NULL, UNIQUE

Constraints

UNIQUE, NOT NULL

NOT NULL

Constraints

UNIQUE, NOT NULL

UNIQUE, NOT NULL

Constraints

UNIQUE, NOT NULL

UNIQUE, NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL
NOT NULL
CHECK ('Scheduled', 'Completed')

Constraints
NOT NULL
NOT NULL
NOT NULL

Constraints
NOT NULL
NOT NULL

Constraints
NOT NULL
NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
CHECK ('Paid', 'Pending')

Constraints

UNIQUE, NOT NULL

NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL

Constraints
UNIQUE, NOT NULL
NOT NULL
NOT NULL
NOT NULL

NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL
Constraints

UNIQUE, NOT NULL

NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL
NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL

NOT NULL, CHECK (insurance_price >= 0.00)

NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL, CHECK (price_per_km >= 0.00)
NOT NULL

Constraints
 UNIQUE, NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL

TEM

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL
NOT NULL

Constraints

UNIQUE, NOT NULL

NOT NULL
NOT NULL, UNIQUE
Constraints
NOT NULL
NOT NULL

Constraints

UNIQUE,NOT NULL
NOT NULL
None

Constraints

UNIQUE,NOT NULL
NOT NULL

Constraints

UNIQUE,NOT NULL
NOT NULL

Constraints

UNIQUE,NOT NULL
NOT NULL

Constraints

UNIQUE,NOT NULL
NOT NULL
NOT NULL

Constraints

UNIQUE,NOT NULL
NOT NULL
NOT NULL
 Constraints

UNIQUE,NOT NULL
NOT NULL
NOT NULL

Constraints

UNIQUE,NOT NULL
NOT NULL

NULLABLE

Constraints

UNIQUE,NOT NULL
NOT NULL

NOT NULL

SYSTEM

Constraints
UNIQUE,NOT NULL
NOT NULL
NOT NULL

Constraints
UNIQUE,NOT NULL
NOT NULL
NOT NULL
NOT NULL
DEFAULT 0

Constraints
UNIQUE,NOT NULL
NOT NULL

NOT NULL
NOT NULL

Constraints
UNIQUE,NOT NULL
NOT NULL

NOT NULL
NOT NULL

Constraints
NOT NULL
NOT NULL
NOT NULL
CHECK(duration > 0)

Constraints

UNIQUE,NOT NULL
NOT NULL
NOT NULL
CHECK(duration > 0)

Constraints
NOT NULL
NOT NULL

NOT NULL
CHECK(available_seats >= 0)

Constraints
NOT NULL
NOT NULL

Constraints
NOT NULL
CHECK(amount >= 0)
NOT NULL

Constraints

UNIQUE,NOT NULL
NOT NULL
NOT NULL
NOT NULL
NOT NULL

Constraints

UNIQUE,NOT NULL
NOT NULL
NOT NULL

Constraints
NOT NULL
CHECK(available_seats >= 0)
Entity Details

Unique identifier for each service selection record

References the category of the service selected

Entity Details

Unique identifier for each service category

The category name (e.g., 'Cleaning', 'Delivery')

Entity Details

Unique identifier for each user

The name chosen by the user

User's email for authentication

Entity Details

Unique identifier for each user

The name chosen by the user

User's email for authentication

Entity Details

Unique identifier for each scheduled appointment

Refers to user_id from USERS table
Refers to service_selection_id from SERVICE_SELECTION table
The address for the appointment
The date and time of the appointment
Payment method (e.g., 'Credit Card', 'UPI')

Entity Details

Unique identifier for each payment transaction

Links to the appointment being paid for
Payment method used
Status of payment (e.g., 'Completed', 'Pending')

Entity Details

Unique identifier for each subcategory.

Refers to category_id from SERVICE_CATEGORIES table
The name of the subcategory (e.g., 'Basic Cleaning', 'Deep Cleaning').

Entity Details

Unique identifier for each most booked service record.

Refers to the browser_service_id from the SERVICES table.
Name of the most booked service (e.g., 'Cleaning', 'Delivery').

Entity Details

Unique identifier for each cart record.

Refers to user_id from USERS table.
The total price of the selected items in the cart.

The discount code applied to the cart (if any).

Entity Details

Unique identifier for the selected package.

Refers to cart_id from CART table.

Entity Details

Unique identifier for each selected option.

Refers to cart_id from CART table.

Entity Details

Unique identifier for each service.

Links the service to a specific subcategory.
Name of the service.
Stores the rating of the service (e.g., 1.0 to 5.0).
Description of the service.
Stores the image related to the service.

Entity Details

Unique identifier for each package.

Name of the package.
Links the package to a specific subcategory.

Entity Details

Unique identifier for each cart item.

References the cart to which the item belongs.

References the service added to the cart.

The number of units of the service in the cart.

The price of the service.

Entity Details

Unique identifier for each home office service record.

The name of the home office service (e.g., 'Cleaning', 'Repair').

Entity Details

Unique identifier for each rating entry.

Identifies the user who provided the rating.
Links the rating to a specific service.

Rating given by the user (1 to 5 scale).

Optional user feedback or comments on the service.

Entity Details

Unique identifier for each booking record.

References the user from the USERS table.
The date and time for the booking.
References the address from the ADDRESS table.
References the payment from the PAYMENT table.
References the status from the STATUS table.

Entity Details

Unique identifier for each address.

References the user from the USERS table.
The actual address for the booking.

Entity Details

Unique identifier for each status.

The status of the booking (e.g., 'Pending', 'Confirmed').

Entity Details

Unique identifier for each stay record.

Name of the stay (e.g., 'Beach Resort', 'Mountain Lodge').
References the LOCATION table
References the CATEGORY table.
Price per night for the stay.
Rating of the stay, represented as a float (e.g., 4.5).
Total number of rooms available at the stay.
References the AVAILABILITY table.

Entity Details

Unique identifier for location.

Name of the location (e.g., city or area name).

Entity Details

Unique identifier for availability status.

Whether rooms are available (TRUE or FALSE).

Entity Details

Unique identifier for each flight-hotel package record.

Refers to the departure airport from the AIRPORTS table.
Refers to the date and time of departure from the DATE_TIME table.
The number of travellers included in the package.
The class of the flight (e.g., 'Economy', 'Business').
The price of the flight-hotel package.
The destination for the package (e.g., 'Paris', 'Tokyo').

Entity Details

Unique identifier for each airport.

Name of the airport.
Location of the airport.

Entity Details
Unique identifier for date & time
Stores departure date & time.

Entity Details
Unique identifier for flight class.
Flight class type.

Entity Details

Unique identifier for each destination.

Name of the destination (e.g., 'Paris').

Entity Details

Unique identifier for each property record.

Refers to the owner_id from the OWNERS table.

Entity Details

Refers to the property.

Name of the property (e.g., 'Oceanview Apartment').
The address of the property.
The price of the property per night.

Entity Details

Refers to the property.

List of facilities (e.g., 'Wi-Fi, Pool').

Entity Details

Unique identifier for each owner.

Entity Details

Unique identifier for each stay booking record.

Refers to the user_id from the USERS table.
Refers to the stay_id from the PROPERTIES table.
The check-in date for the booking.
The checkout date for the booking.
Refers to the payment_id from the PAYMENTS table.
Entity Details

Refers to the booking record.

The number of adults staying at the property.
The number of children staying at the property.

Entity Details

Refers to the booking record.

The total price for the stay booking

Entity Details

Refers to the booking record.

The status of the booking.

Entity Details
Unique identifier for each car rental.
References car type from the CAR_TYPES table.
References pickup location from the LOCATIONS table.
Total rental price.
References the company from the RENTAL_COMPANIES table.
Rating of the car rental service.
Refers to the availability status from AVAILABILITY_STATUS table.
Price charged per day for renting the car.

Entity Details

Unique identifier for each car type.

Car type details (e.g., Sedan, SUV, Hatchback).

Entity Details

Unique identifier for each rental company.

Name of the rental company.

Entity Details

Unique identifier for each currency record.

The code for the currency (e.g., 'USD', 'EUR').
The name of the currency (e.g., 'Dollar', 'Euro').

Entity Details

Unique identifier for each flight

Official flight number assigned by the airline
References the airline operating the flight
Defines flight type

Entity Details

Unique schedule ID
Links to flight details
Departure city reference
Arrival city reference
Scheduled departure time
Scheduled arrival time

Entity Details

Unique schedule ID
Links to flight details
Ticket price
Stops classification
Links baggage details
Links to fare conditions

Entity Details

Unique rental location ID

Links to car rental service
Pickup location
Availability status reference

Entity Details

Unique ID for pricing details

Links to car rental details
Total rental price
Rental service rating
Entity Details

Unique baggage ID
Baggage allowance details

Entity Details

Unique ID for fare rules

Refund and cancellation rules

Entity Details

Unique identifier for each booking.

References the user who made the booking.
Identifies the specific car being rented.
Links to the payment transaction.

Entity Details

Links to Car_Rental_Bookings.
Specifies where the car will be picked up.
Specifies where the car will be returned.

Entity Details

Links to Car_Rental_Bookings.
The date and time the rental starts.
The date and time the rental ends.

Entity Details

Unique identifier for the payment transaction.

The total cost of the rental.

Entity Details

Unique identifier for each payment transaction.

References the user who made the payment.
Stores the unique transaction reference number.
References the cart associated with this payment.
Date of payment transaction.
Amount paid in the transaction.

Entity Details

Unique identifier for each payment method.

Stores method type (e.g., 'Credit Card', 'Debit Card', 'UPI', 'Net Banking', 'Wallet').

Entity Details

Unique identifier for payment status.

Stores payment status (e.g., 'Pending', 'Completed', 'Failed', 'Refunded').

Entity Details

References Payment(payment_id).
References Payment_Method(method_id)
References Payment_Status(status_id).

Entity Details

Unique identifier for each price alert.

References the user who set the price alert.
References the flight for which the price alert is set.
The target price at which the user wants to receive an alert.

Entity Details

Unique identifier for each taxi.

Name of the driver operating the taxi.
The type of vehicle (e.g., 'Sedan', 'SUV', 'Hatchback').
The cost per kilometer for using the taxi.

Entity Details

Unique identifier for each cart entry.

References the user who owns the cart.
The type of item (e.g., 'Product', 'Service').
The identifier of the item added to the cart.
The number of units of the item in the cart.
Entity Details

Unique identifier for each taxi.

Name of the driver.
Type of vehicle.
Cost per kilometer

Entity Details

Unique identifier for each booking.

References the user making the booking.
References the taxi assigned to the booking.
Pickup location of the user.
Drop-off location of the user.
Estimated fare for the ride.
References the payment transaction.
Current status of the booking.

Entity Details

Unique identifier for each customer service entry.

Defines the type of support provided.
Frequently asked question related to the support type.
Contact information for customer support (e.g., phone number, email).

Entity Details

Unique identifier for each attraction.

Name of the attraction (e.g., "Zoo", "Museum").

References the location of the attraction.

References the type of attraction.

Entity Details
Unique identifier for each category.
Type of attraction (e.g., Museum, Park, Zoo).

Entity Details

Unique identifier for each event.

References the attraction for the event.
Scheduled event time for the attraction.
Entry fee for the attraction.

Entity Details
Unique identifier for each booking.
Identifies the user making the booking.
Identifies the attraction being booked.
Total price for the booking.
Links to the payment transaction.
Status of the booking.

Entity Details

Links to the booking.

Number of adult visitors.
Number of child visitors.

Entity Details

Unique identifier for each coupon.

The unique code that users apply for a discount.
Discount percentage offered by the coupon.
The date after which the coupon is no longer valid.

Entity Details
Unique identifier for each driver.
Name of the driver.
The phone number of the driver.

Entity Details

Links to the driver.

The rating of the driver (e.g., 4.5).

Entity Details

Links to the driver.

The driver's license number.

Entity Details

Links to the driver.

Refers to the vehicle_id from the VEHICLES table.

Entity Details

Unique identifier for each ride booking.

Refers to the user_id from the USERS table.
Refers to the driver_id from the DRIVERS table.
The timestamp when the booking was made.
The status of the ride.

Entity Details
Links to the ride.
The pickup location for the ride.
The drop location for the ride.

Entity Details
Links to the ride.
The scheduled date for the ride.

Entity Details
Links to the ride.
Refers to the payment_id from the PAYMENTS table.
The price for the ride.

Entity Details

Unique identifier for each ride fare record.

Refers to the ride_id from the RIDES table.
The status of the fare.

Entity Details

Unique identifier for base fares.

Refers to the base fare from the BASE_FARES table.

Entity Details

Links to the ride fare.

Discount or offer applied to the fare for the user..

Entity Details

Links to the ride fare.

The final fare after applying the base fare and any offers.

Entity Details
Unique identifier for each customer support record.
Refers to the user_id from the USERS table.
Type of support (e.g., 'Technical', 'Billing').
The query or issue raised by the customer.
The response provided to the customer.
The current status of the support request (e.g., 'Open', 'Closed').

Entity Details

Unique identifier for each booking record.

Refers to the user_id from the USERS table.
The status of the booking.
Entity Details

Refers to the booking in the BOOKING table.

Refers to the ride_id from the RIDES table.

Entity Details

Refers to the booking in the BOOKING table.

Refers to the rental_id from the RENTALS table.

Entity Details

Unique identifier for each rental transaction.

References the user who made the rental.
Status of the rental.

Entity Details

References the rental in the RENTALS table.

Identifies the rented vehicle.
Duration of the rental (in hours or days).
The total cost of the rental.

Entity Details

Unique identifier for each ride insurance entry.

References the ride for which insurance is applied.

Cost of the insurance for the ride.

Name of the insurance

Entity Details

Unique identifier for each vehicle.

The type of vehicle (e.g., 'Car', 'Bike', 'Van', 'Bus').
The price charged per kilometer for the vehicle.
The availability status of the vehicle (e.g., 'Available', 'Booked', 'Under Maintenance').

Entity Details
Unique identifier for each payment.
References the user who made the payment.
References the ride for which the payment was made.
References the rental for which the payment was made.

Entity Details

Unique identifier for each payment history record.

References the payment associated with this record.
URL link to the payment receipt or invoice.

Entity Details

Unique identifier for each ride-vehicle mapping.

Links the vehicle to a specific ride.
Identifies the vehicle used for the ride.

Entity Details

Unique identifier for each booking record.

Date when the shifting is scheduled.
The time slot for the booking.
The price for the shifting service.

Entity Details

Unique identifier for each contact.

Links to BOOKING(booking_id).
Phone number associated with the booking.
Entity Details
Refers to the booking_id from the BOOKING_SECTION table.
Refers to the service_id from the SERVICES table.

Entity Details

Unique identifier for each service record.

Name of the service (e.g., 'Cleaning', 'Delivery').
Description of the service (e.g., 'Standard cleaning service').

Entity Details

Refers to the booking_id from the BOOKING_SECTION table.

Refers to the service_id from the SERVICES table.

Entity Details

Unique identifier for each value-added service.

The name of the additional service.
Description or additional details about the service.

Entity Details

Identifies the booking to which the service is linked.

Identifies the additional service associated with the booking.

Entity Details

Unique identifier for each other service.

References the name of the service.
Description of the additional service.

Entity Details

Unique identifier for each value-added service.

The name of the value-added service.
Description of the additional service.
Entity Details

Unique identifier for each testimonial.

References the user who provided the testimonial.
The rating given by the customer (1.0 - 5.0).
Links the testimonial to a specific booking.

Entity Details

Unique identifier for each testimonial.

References the user who provided the testimonial.
The rating given by the customer (1.0 - 5.0).
Links the testimonial to a specific booking.

Entity Details

References the testimonial in the TESTIMONIALS table.

URL of the video testimonial (if available).
Text review provided by the customer.

Entity Details
Unique identifier for each play
The title of the play
The location where the play is performed

Entity Details
Unique identifier for each play schedule
Links to the play
The date of the play performance
The time at which the play is scheduled
Number of available seats

Entity Details
Unique identifier for each corporate offer.
Refers to the company_name from the COMPANIES table.
Refers to the offer_details from the OFFERS table.

The validity date of the corporate offer.

Entity Details
Unique identifier for each movie.
The title of the movie.
The official release date of the movie.

The current status of the movie.

Entity Details
References the MOVIES table.
The genre(s) of the movie (e.g., Action, Comedy, Drama).
The language(s) in which the movie is available.
The duration of the movie in minutes.

Entity Details

Unique identifier for each sports event.

The title or name of the sports event.
The type of sport (e.g., Football, Cricket, Basketball).
The venue where the event is taking place.

Entity Details
References the SPORT_EVENTS table.
The date when the event will be held.
The time when the event is scheduled.

The number of available seats for booking.

Entity Details
Unique identifier for each gift card.
References the user who owns the gift card.
A unique code assigned to the gift card.

Entity Details
References the GIFT_CARDS table.
The balance or value of the gift card.
The date after which the gift card is no longer valid.

Entity Details

Unique identifier for each showtime.

References the movie being shown.
References the theater where the movie is playing.
The date on which the movie will be shown.
The time at which the movie will be screened.

Entity Details

Unique identifier for each theater.

The name of the theater.
The address or location of the theater.

Entity Details
References the SHOW_TIME table.
The number of seats available for booking.