Sr No Main Functionality Functionality

Home Page

Service Selection

1 Personal Care Services

 Browser Services

Home Page

Service Selection

House & Office

2
Services
 Cart

Stays

Flights

3 Travel & Booking

3 Travel & Booking

Flight + Hotel

Car Rentals

Attractions

Airport Taxis

Customer Service

Ride Booking
 Vehicle Selection

Fare Options
4 Intercity Rentals

Payment Options

Booking History

Customer Support
Add-Ons

Booking Section

Services Overview

5 Home Shifting

Value Added Services

Other Services
 Other Services

Customer Testimonials

Movies

Stream

Event / Movie Events

6
Ticket Booking

Plays
Sports
Activities
List Your Show
Offers
Gift Cards
Sub Functionality

Subcategories:
Men's Services

Women's Services
 Women's Services

Special adds and discount prices

Most booked services

Special adds and discount prices

Most booked services:

Wall Panles

Wall Painting

Water Purifires

Electrical Repairs

AC Repair & Service

Paste Control
 Home Cleaning

Quick Home Repairs)

Lists service packages

Search Form

Popular Destinations

Flight Search
 Package Deals

Car Search

Attraction Tickets

Taxi Booking

Support Access

Book a Ride

Schedule a Ride
 Choose Vehicle Type
View Driver Details
Enter Your Offer
Select Rental Package

Select Payment Method

View Rides

FAQs
Insurance for Rides
Pickup Location Field

Drop Location Field

Phone Number Field

Shifting Date Selector

Check Price Button
Reliable Shifting

Economical Prices

Damage-Proof Packaging

Rope Pulling Services

Installation of Appliances

Professional Electrician
Professional Carpenter
All India Parcel

Trucks
 Trucks

Two Wheelers

User Reviews Section

Now Showing
Upcoming
Genres
Languages
Featured Streams
New Releases
Genres
Music Shows
Comedy Events
Workshops
Upcoming Plays
Upcoming Sports Events
Outdoor Activities
Indoor Activities

Current Offers
Purchase Gift Cards
Sub-Sub-Functionality

Salon for Women

Spa for Women
Hair studio for women
Makeup & Styling Studio

Salon for Men & Kids

Massage for Men
 Salon for Men & Kids
Massage for Men

Book the special packgae's with offer

Most booked services:

Salon for women
Roll-on with style

Hair & nail services

Moset booked services: (Wall Panels, Wall Painting, Wall Upgrading, Electrical
Repairs, Wall Panles, Water Purifires, Native Smart Loks, AC Repair & Service,
Home Cleaning (Package), Paste Control, Quick Home Repairs)

Wall Panles Categories:

(Luxury Bathroom, Luxury Bedroom, Luxury Dining room, Luxury Dressing,
Luxury Living room)

Wall Painting: (Full home painting & Few walls , rooms)

Water purifires (varients) (Add to Cart)

Events offers

Electrician Service Package (Add to Cart)

Select offers, rewards & Cashback

AC Repair & Service: (Servicing, Repair & gas refilling, Installation &
uninstallation

Paste Controles:
Category ( Kitchen/Bathroom, Apartment/Bunglow, Office/Shops)
Home Cleaning Package: (Bathroom Clraning, Kitchen cleaning, Full Home
Cleaning, Sofa & Carpet Cleaning)

Emergency Service:
(Option for urgent booking (if available))

Booking details
Date & Time Picker

Filter Results

Sort Options

Destination Page

Flight Options:
(Best, Cheapest, Fastest)
Flight Stops:
(Any Stop, Direct Only, 1 Stop Only)
Airline Type:
(Indigo, Air India, Air India Express)

Price Alerts
 Customization:
(Departure Airport Name, Destination Name, Date & Time, Travellers &
Flight Class)

Add-ons

Filter by Car Type

Rental Company Reviews

Category Browsing

Availability Calendar

Price Estimator

Driver Details

FAQ Section
Contact Options
Select Pickup & Drop

Set Date & Time

 View Price & Availability
Contact Driver
Negotiate or Accept Offer
Confirm Duration
Add Payment Details
Apply Coupons
View Payment History

Cancel Booking

Contact Support
Confirm Add-On
Auto-detect Location Option
Manual Entry Field
Suggestive Dropdown
Manual Entry Field
Validation Check
OTP Verification
Calendar View
Time Slot Selection
API Call
On-Time Guarantee Badge
Quality Assurance Badge
Price Comparison Table
Discount Badges
Packaging Types List
Customer Testimonials
Weight Capacity List
Safety Precautions Guide
Appliance Types Covered
Technician Availability
Available Services List
Furniture Types Covered
Parcel Size Options
Delivery Speed Options
Truck Types List
Driver Availability Checker
Vehicle Safety Measures
Delivery Time Estimate
Star Rating System
Video Testimonials
Movie Details
Movie Details
Genre-Specific Movies
Language-Specific Movies
Stream Details
Stream Details
Genre-Specific Streams
Event Details
Event Details
Event Details
Play Details
Event Details
Activity Details
Activity Details
 Sub-Sub-Sub-Functionality

Salon Prime: (Complete honey waxing, Complete chocolate roll-on waxig, Wax & glow,
Waxing & hair care, Mani-pedi indulgence, Complete care, Make your own package,
Facial, Ayurvedic Facial, Cleanup, Pedicure & maincure, Hair/ bleach & detan, Threading
& Face waxing)
Add to cart, Update Quantity, Edit Package, View offers
View Cart

Spa for Women:

(Ayurveda: 4 seasons Abhyangam full-body stress relief massage, Vedic signature full
body pain relief massage, Warm Abhyangam full-body massage hot bed, Stress relief,
Pain relief, Ayurvedic skin care etc…)
Prime: Deep tissue pain relief massage, Stress relief swedish massage, post natal
massage, Hectic dat care stress relief massage etc...
Luxe: Sublime Swedish therapy, Deep tissue healing therapy, warm swedish therapy,
Warm nirvana therapy,Balinese therapy, Holistic aromatherapy, Healing potil therapy
etc...)
Add to cart, Update Quantity, Edit Package, View offers
View Cart

Hair Studio Packages: (Hair spa & cut, Hair spa & style, Haircut & styling ,Hair trim &
styling, Hair trim & spa, Cut & color, Cut & botbox/kertin, Weeding-ready group
hairstyling, Hair Extensions, Fashion Color, Proceed for Payment or Add to Cart)
Add to cart, Update Quantity, Edit Package, View offers
View Cart

Makeup Studio Packages: (Basic Makeup, Luxe makeup, Professional makeup,

Glam-up makeup, HD finish makeup, Makeup & hairstyling, Customize own makeup,
Proceed for Payment or Add to Cart)
Add to cart, Update Quantity, Edit Package, View offers
View Cart

Salon for Kids & Men:

(Royal: Gromming essentials, Complete care, Glow getter, Cut & color, Feet care &
beyond, Pedicure, Hair cut Men / Kids, Face care, Shave.beard grooming, Hair color etc...
Prime: Weeding ready package, Feet care & beyond, Hair cut & beard styling etc...)
Add to cart, Update Quantity, Edit Package, View offers
View Cart
 Massage for Men:
(Prime: Prime: Deep tissue pain relief massage, Stress relief swedish massage, post natal
massage, Hectic dat care stress relief massage etc...
Royal: Sublime Swedish therapy, Deep tissue healing therapy, warm swedish therapy,
Warm nirvana therapy,Balinese therapy, Holistic aromatherapy, Healing potil therapy
etc...)
Add to cart, Update Quantity, Edit Package, View offers
View Cart

Book package
Add to cart, Update Quantity, Edit Package, View offers
View Cart

Select Service
Add to cart, Update Quantity, Edit Package, View offers
View Cart

Haircut, Elysian british rose pedicure, massage

Hair & Nail services: (In curl/out blow dry, Makeup & Hairstyle, Hairtrim etc)
Add to cart, Update Quantity, Edit Package, View offers
View Cart

Select Service
Add to cart, Update Quantity, Edit Package, View offers
View Cart

Select Service
Add to cart, Update Quantity, Edit Package, View offers
View Cart

Select Service
Add to cart, Update Quantity, Edit Package, View offers
View Cart

Select Service
Add to cart, Update Quantity, Edit Package, View offers
View Cart

Electrician Services:
(Switch & socket, Fan, Wall/celling light, Appliance, Wiring, Doorbell, MCB & submeter,
Inverter stabiliser, Book a electrician visit)
Add to cart, Update Quantity, Edit Package, View offers
View Cart

Select Service
Add to cart, Update Quantity, Edit Package, View offers
View Cart

Paste Control Service: (Cockroach, Ant & General Pest Control, Termite Control, Bed
Bugs Control)
Select Service
Add to cart, Update Quantity, Edit Package, View offers
View Cart
 Select Service
Add to cart, Update Quantity, Edit Package, View offers
View Cart

Select Service
Add to cart, Update Quantity, Edit Package, View offers
View Cart

Select an address
Select date & time slots
Select payment methods
Coupons and offers section
Cancellation policy

Search destination name

Popular Destination
Checkin Date / Checkout date
Catagorise Selection Adults, Childerns & Rooms

Use Different offers & Coupns

Brows Property Type:
(Hotels, Apartments, Resorts, Villas, Cabins)
Sort by price,Reviews or distance.
Select Service
Add to cart, Update Quantity, Edit Package, View offers
View Cart

Popular destination names:

(Goa, Ooti, New Delhi, Mumbai, Bangalore etc…)
View information
(trending destinations, Top properties, Ratings)
Select Service
Add to cart, Update Quantity, Edit Package, View offers
View Cart

Flight:
(View Details, Departue Time, Arrival Time)
All Flight Info:
(Baggage, Fare Rules)
Search flights specifying departure/arrival cities and dates.
Select Flight:
(Standard Ticket, Flexible Ticket)
Price Breakdown Summary
Contact Details,Adults Selection
Add to cart, Update Quantity, Edit Package, View offers
View Cart

-
 Flight Search:
(Packages List & price, Select package, Flight Details)
Selection Accomodation & board Type:
(General Info / Facilities)
Modify Details:
(Flight and hotel Combinations, Budget and preferences)
(Personlize Info,Traveller Details, Flight Details)
Special Assistance
Price Breakdown Summary
Add to cart, Update Quantity, Edit Package, View offers
View Cart

-
-

Categories:
(Museums, Tour, Shows)
Event Time
Booking: Adults,Childern
Add to cart, Update Quantity, Edit Package, View offers
View Cart

Date & Time: Specific attractions.

Event Time

Estimate costs Based on location & timing.

Add to cart, Update Quantity, Edit Package, View offers
View Cart
View driver and vehicle details
Add to cart, Update Quantity, Edit Package, View offers
View Cart
-
-
-

-
-
-
-
-
-
-
-

-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
 Features
"Personal Care" services

View Cart:
Select Mobile No
Select Address
Select Date & Time slot
Payment Method: (Credit Card, Debit Card, Mobile Wallet, Net Banking)
Payment Summery
Cancellation Policy
 Explore House & Office Services

View Cart:
Select Mobile No
Select Address
Select Date & Time slot
Payment Method: (Credit Card, Debit Card, Mobile Wallet, Net Banking)
Payment Summery
Cancellation Policy
 Search accommodations by destination
Dates
Guest info filtering options.

View Cart:
Select Mobile No
Select Address
Select Date & Time slot
Payment Method: (Credit Card, Debit Card, Mobile Wallet, Net Banking)
Payment Summery
Cancellation Policy

Set alerts for price drops on specific flight routes.

 View Cart:
Select Mobile No
Select Address
Select Date & Time slot
Payment Method: (Credit Card, Debit Card, Mobile Wallet, Net Banking)
Payment Summery
Cancellation Policy

Add travel insurance

meals or extra luggage.
Search rental cars by pickup location
Dates and specific car types (e.g., SUV, sedan).
View ratings and reviews of rental agencies.

View Cart:
Select Mobile No
Select Address
Select Date & Time slot
Payment Method: (Credit Card, Debit Card, Mobile Wallet, Net Banking)
Payment Summery
Cancellation Policy

Booking: Adults,Childern
View Cart:
Select Mobile No
Select Address
Select Date & Time slot
Payment Method: (Credit Card, Debit Card, Mobile Wallet, Net Banking)
Payment Summery
Cancellation Policy

View Cart:
Select Mobile No
Select Address
Select Date & Time slot
Payment Method: (Credit Card, Debit Card, Mobile Wallet, Net Banking)
Payment Summery
Cancellation Policy

Frequently asked questions Troubleshooting & guidance.

Contact customer service via chat, email, or phone support.
Book rides
Flexible pickup & drop.
Schedule rides in advance
Specified timing.
 Select various vehicle options
preference & cost.
Access driver information
Suggest or negotiate fares
Intercity travel.
Rent vehicles for a predefined time
Choose from cards, UPI, wallets, or cash for rides.
Confirm Payment
Download Receipt

Access past rides

Cancel ongoing bookings.
Resolve queries via FAQs
Direct customer support options.
Add optional insurance coverage for rides.
Fetches user's current location.
Allows manual input pickup location.
Provides dropdown
suggested locations.
Manual input destination.
Phone number validaation
before proceeding.
Sends OTP number authentication.
Displays calendar to pick date.
Select preferred time slots.
Fetches real-time pricing
Displays timely delivery.
Highlights commitment to quality services.
Price comparison against competitors.
Displays any ongoing discounts or offers.
Details types of packaging (e.g., bubble wrap, boxes).
Feedback emphasizing safe delivery.
Lists weight capacities
Details measures safe handling.
Lists appliances installation.
Shows time slots for technicians.
Details services
(wiring, socket fixing, etc.)
Highlights types of furniture eligible for services.
Lists available sizes for parcels (small, medium, large).
Provides options for express or standard delivery.
Details available truck options (mini, medium, large).
 Shows available drivers for selected trucks.
Safety measures
two-wheeler,transport.
Provides estimated delivery times.
Displays average star ratings.
Showcases video feedback
View current movies, showtimes, and book tickets.
Preview upcoming movies and release dates.
Browse movies by genre.
Browse movies by language.
Access featured movies and shows
Discover newly released streaming content.
Browse streaming content by genre.
Book tickets for music events.
Book tickets for comedy shows.
Book tickets for workshops.
View and book tickets for upcoming plays.
View and book tickets for upcoming sports events.
Discover and book outdoor activities.
Discover and book indoor activities.
Partner with BookMyShow to list your event.
View current promotional offers and discounts.
Buy gift cards for various occasions.
Referance App

Urban Company,
Urban Company,
Urban Clap
Booking.com
 Booking.com

rapido.bike, intercity.indrive.com,
uber.com

uber.com
 rapido.bike, uber.com
intercity.indrive.com
intercity.indrive.com
rapido.bike, uber.com

uber.com
intercity.indrive.com, uber.com

rapido.bike, intercity.indrive.com,
uber.com
rapido.bike, intercity.indrive.com,
uber.com
uber.com

Porter Packers and Movers Pune

BookMyShow Pune
Module Main functionality Functionality Sub-Functionality
Personal Care Services List services Add to categories

Pop up new work Option

Woks Details

Accepting work Customer details

Assign work Pop up to all employee

House And Office Services List services Add to categories

Pop up new work Option

Woks Details

Accepting work Customer details

Assign work Pop up to all employee

Travel And Booking Hotel name

List rooms Add to categories
 Pop up booking request Verify customer

Booking confirmation Payment

Bus name
List Buses Add to categories

Pop up booking request Verify customer

Booking confirmation Payment

Service Based App

Intercity City name

List vehicials Add to categories
 Pop up booking request Verify customer

Booking confirmation Payment

Houseshifting City name

List vehicials Add to categories

Pop up booking request Verify customer

Booking confirmation Payment

Movie & Event Booking Theater name

City name
List of movies Add to categories(Genre)

Pop up booking request Verify customer

Booking confirmation Payment

Sub-Sub functionality Features (it going to work on docker images )
Add category Form to accept service category
Add sub-category Form to accept service sub-category
Add service From to accept the service
Price
Date & Time Calander
Time
Address Select from Map's
Enter address manually Form to accept address
Drop down (state & city)
Accept
Reject
Customer name
Mobile no
Work
Address
Customer location Select from Map's
Enter location manually longitude and latitude
Employee status Accept
Reject
Add category Form to accept service category
Add sub-category Form to accept service sub-category
Add service From to accept the service
Price
Date & Time Calander
Time
Address Select from Map's
Enter address manually Form to accept address
Drop down for state & city
Accept
Reject
Customer name
Mobile no
Work
Address
Customer location Select from Map's
Enter location manually longitude and latitude
Employee status Accept
Reject
Form to accept name
Add category Form to accept room category
Add sub-category Form to accept room sub-category
Add room From to accept the room
Price
Date & Time Calander
 Time
Address Select from Map's
Enter address manually Form to accept address
Drop down for state & city
Check box
Check room avalibility Yes
No
Check dates Calander
Payment option
Payment options (UPI, Net banking,Card)

Payement status Done

Pending
Failed
payment status done Room booked
Form to accept bus name
Add category Form to accept bus category
Add sub-category Form to accept bus sub-category
Add bus From to accept the bus
Price
Date & Time Calander
Time
Address Select from Map's
Enter address manually Form to accept address
Drop down for state & city
Check box
Check bus avalibility Yes
No
Check dates Calander
Pick up point Select from Map's
Drop point Select from Map's
Payment option
Payment options (UPI, Net banking,Card)

Payement status Done

Pending
Failed
payment status done Bus booked
Drop down for state & city
Add category Form to accept vehicials category
Add sub-category Form to accept vehicials sub-category
Add vehicial From to accept the vehicial
Price
Date & Time Calander
Time
Address Select from Map's
Enter address manually Form to accept address
Drop down for state & city
Check box
Check bus avalibility Yes
No
Check dates Calander
Pick up point Select from Map's
Enter address manually Form to accept address
Drop down for state & city
Drop point Select fromMap's
Enter address manually Form to accept address
Drop down for state & city
Payment option
Payment options (UPI, Cash)

Payement status Done

Pending
payment status done Ride booked
Drop down for state & city
Add category Form to accept vehicials category
Add sub-category Form to accept vehicials sub-category
Add vehicial From to accept the vehicial
Price
Date & Time Calander
Time
Address Select from Map's
Enter address manually Form to accept address
Drop down for state & city
Check box
Check vehicials avalibility Yes
No
Check dates Calander
Pick up point Select from Map's
Enter address manually Form to accept address
Drop down for state & city
Drop point Select from Map's
Enter address manually Form to accept address
Drop down for state & city
Payment option
Payment options (UPI, Cash)

Payement status Done

Pending
payment status done Shifting booked
Form for theater name
Drop down for state & city
Add category based on genres Form to accept category
Add sub-category based on genres Form to accept sub-category
Add movie & Event From to accept the movie and event
Price
Date & Time Calander
Time
Address Select from Map's
Enter address manually Form to accept address
Drop down for state & city
Check box
Check seat avalibility Yes
No
Check dates Calander
Theater or Event location Select from Map's
Enter address manually Form to accept address
Drop down for state & city
Payment option
Payment options (UPI, Cash)

Payement status Done

Pending
payment status done Movie or Event booked
Refering's App Sprint
Urban Company, Booking, Bookmyshow, Rapido
Module Main functionality Functionality Sub-Functionality Sub-Sub functionality
Profile Onbording documents Identity proof Pan or Adhar

Persnol Details Profile photo

Full name
Mobile no
Email
Gender
DOB
Address Current location
Enter manually
Self declaration
Guide Instructions

Bank details Banking Bank name

Account no
Branch name
IFSC code
Upi UPI id
Account verification Status

Experience Years 0 - 1 yrs

1 -3 yrs
3 + yrs
Previous work Organization name
Service Based App Work
Verify address Full name
Mobile no
Address line 1
Address line 2
Pincode
State
City

Home Book your work

What work you want do

No of order you want to do
No of hrs you want to wark

Done woks
Pending work
New jobs Search
Filter
Avaliable work

Ongoing All ongoing work Search

Filter

Money Your earnings

Bank transfer Status

Wallet
Features (it going to work on docker images ) Refering's App Sprint
Select form files
Select from camera
Select from photos
Select form files
Select from camera
Select from photos

Form of user details

Drop down
Calander
From maps
Full address
Check box
Images
Video

Form of bank details

Account activated
Account not activated

Form of no of yrs of experience

Form of prevoius work experience

Urban Company, Booking, Bookmyshow, Rapido

Form of bank details

Drop down (All state name)

Drop down(All the cities of selected state)
Confirmation
Calander
Time
Drop down (List all the works)
Drop down (add numbers)
Time
Confirmation
work done today
pending work for today
Search bar
Filter button
avaliable work
Work acceptance
Search bar
Filter button
ongoing work
earning
Deopsite
Ongoing
Add earinings into wallet
Module Main functionality Functionality Sub-Functionality
User Management User accounts Manage Users

Authentication
Subscription plans Manage plans
Service Management Categories Assign Categories

Allocation Assign Professionals

Status Tracking Monitor Bookings

Payment Management Gateway Integration Setup payments modes

Service Based App

Transactions Monitor Payments

Fees & Commission Calculate Admin Fees
Reports & Insights Analytics Booking Analytics
Revenue Tracking View Monthly Trends
Notifications Pop up alerts Notify Users

Pop up notification of booking Notify Admin

Feedback Requests Collect Reviews
Security & Logs Data Privacy Monitor Permissions
Activity Logs Track Business Actions
Track employee Actions
Sub-Sub functionality Features (it going to work on docker images )
Add Profiles Create user accounts
Edit Profiles Update user accounta
Delete Profiles Delete user accounts
Verify Accounts Secure login with 2FA
Enable/Disable Plans
Add service
Edit service
Auto Assignments
Assign service to service provider
Manual Assignments
Ongoing Status
Service status
Completed Status
Payment options UPI
Card
Cash
Transaction history
Fee Reports with platform fees
Generate Reports Drop down (Daily,weekly,monthly report)
Analyze Profit Breakdown Monthly revenue reports
Updates
Reminders
Pop up (Booking)
Post-Service Feedback Reviews
Access per GDPR
Business & Employee reports
Refering's App Sprint

Urban Company, Booking, Bookmyshow, Rapido

Repository Docker Image Name Docker Image Id's
SA_Business_Register as Drop down with business options f3c1e8b7a6d2
SA_Business_Business name Form for details (name) b2d6f9a5e7c1
SA_Business_Business field Drop down with different fields a9c2d3f6b4e7
House And Office Services c8f2d1a6b5e9
SA_Business_Contact no Form for details(contact) d7a3e9c6b1f4
SA_Business_Email Form for details (email) e5f9b2d7c8a3
SA_Business_Address Map's f6d1e7c9a4b2
SA_Business_Enter manually Form for address a3b7f9d5e1c8
Drop down for state & city d4e9b1c6a5f2
SA_Business_Full name Form for details (Full name,mobile no, email) e6f3d2c8a7b9
SA_Business_Address Map's b7e1a4f3d9c2
SA_Business_Enter manually Form for address f8b3d7a5e6c1
Drop down for state & city d9a2e7c1b5f3
SA_Business_Pan or Adhar Select from system c4f8d2a6b9e3
Select from camera e1b5d6c9f2a7
Select from photos f5c3a8d9b1e6
SA_Business_Phone verification OTP b6d9e3a5c7f2
SA_Business_Email varification OTP f3a1e8d7c5b9
SA_Business_id Select from system d6c2f9a7e5b1
Select from camera e9b6f3a1c5d7
Select from photos c3d2f7b1a9e5
SA_Business_Proof of address Select from system f4a2e9c6d7b3
Select from camera b5e3f2a6d7c9
Select from photos e1a8d4f9b7c2
SA_Business_GST no Select from system d9f5c3a7b1e2
Select from camera a3b9d2e7f5c8
Select from photos f7c9d1e5b6a3
SA_Business_ISO certificate Select from system b1e3f9a7c5d8
Select from camera e9b7d6c5f2a3
Select from photos f5c2a6b9d3e1
SA_Business_Work place Select from system c8d7f3e9a4b2
Select from camera b4e2d1f7c9a5
Select from photos f6a9b3c2d7e1
SA_Business_Worker working images & videos Select from system d1f9e5c8b3a7
Select from camera c7b6e2f1d3a9
Select from photos e3a2d5f7b8c9
SA_Business_Display all terms and conditions Agree button f1c9b7a5e6d2
SA_Business_Payment options UPI d4b2f9c8a3e7
Net banking e9b1a5c6f2d3
Card c6d8f9a1b3e2
SA_Business_Digital signature Name ,Email b3a9e7d1f2c5
SA_Business_Add category Form to accept service category f2d1e9c6b8a7
SA_Business_Add sub-category Form to accept service sub-category a6b3e7f1d9c5
SA_Business_Add service From to accept the service d9e7b5c3a2f1
 Price e1c6b9f5d8a2
SA_Business_Date & Time Calander c2f3d9a5b1e7
Time b7f2c8a1e3d6
SA_Business_Address Map's d5b6c9e2a7f3
SA_Business_Enter address manually Form to accept address e9c4a5b7d6f2
Drop down for state & city c8a1b7f3d5e9
SA_Business_Option Accept b3f6d9a1e7c2
Reject f2d5a9b7c6e3
SA_Business_Customer location Map's d7e2b1c5f3a9
SA_Business_Enter location manually longitude and latitude c3a9e7d5b2f6
SA_Business_Employee status Accept b8e3d2f7c1a9
Reject f1d5c6b7a9e2
SA_Business_Add category Form to accept service category d6b9a3f1e7c2
SA_Business_Add sub-category Form to accept service sub-category e4a1b7c2f6d9
SA_Business_Add service From to accept the service c9e7d1b3a5f2
Price b6f3a9d2c8e1
SA_Business_Date & Time Calander e2d9b1f7a3c5
Time f7a9b2d6e5c1
SA_Business_Address Map's b9c6a7f3d1e2
SA_Business_Enter address manually Form to accept address (Input) c4d5f9a2b3e7
Drop down for state & city e9b3a1d7c2f5
SA_Business_Option Accept d8b1f6c2e9a7
Reject f5a2c7b9e6d1
SA_Business_Customer location Map's c7b6f5d9a1e3
SA_Business_Enter location manually longitude and latitude d2a9f6c1e3b7
SA_Business_Employee status Accept b7d3f9c2e8a1
Reject f3a6c1b7e5d9
SA_Business_Hotel name Form to accept name d5c2e9f1a8b7
SA_Business_Add category Form to accept room category b8f9a6d1e3c2
SA_Business_Add sub-category Form to accept room sub-category e3a7f2d9b6c1
SA_Business_Add room From to accept the room c5d1b9e3a8f7
Price f1b6c3a7d9e2
SA_Business_Date & Time Calander d7c9f5b1a2e6
Time b2e1f3a7c9d5
SA_Business_Address Map's e8b3f6d1a7c9
SA_Business_Enter address manually Form to accept address f9b2c5a7d3e6
Drop down for state & city d6c2b1a3f9e7
SA_Business_Verify customer Check box for verification c1d9b6a7e5f3
SA_Business_Check room avalibility Yes e4f9a3b2d7c6
No f2c7d5e9b1a6
SA_Business_Check dates Calander b9a1c6d7f3e5
SA_Business_Payment option UPI d1c9f5b7e8a2
Net banking c7a6b9d2f5e1
Cards e5c3d9b7a1f6
SA_Business_Payement status Done f9b2a3d7c6e1
 Pending d8e5b1a6f7c9
Failed c2f7b6d3e9a5
SA_Business_payment status done Room booked b1d2f9e3a7c6
SA_Business_Bus Name Form to accept bus name f6b3c7d9a1e2
SA_Business_Add category Form to accept bus category d5a9e2b7f6c3
SA_Business_Add sub-category Form to accept bus sub-category c9f5b2d1a3e7
SA_Business_Add bus From to accept the bus b8c7d1e2f9a6
Price e1b3f5d9a7c2
SA_Business_Date & Time Calander c6a9d7b5f2e1
Time d2e5f3a6b7c9
SA_Business_Address Map's f1b2d9c3a7e5
SA_Business_Enter address manually Form to accept address b7f5c1a9d6e3
Drop down for state & city e9b6c1d5a7f3
SA_Business_Verify customer Check box for verification f5a3b9e1d7c2
SA_Business_Check bus avalibility Yes d3c9f6b7a1e5
No c5e2b9f7a3d1
SA_Business_Check dates Calander f8c1b3d7a9e2
SA_Business_Pick up point Map's d2e3f9c5b7a1
SA_Business_Drop point Map's c7b9f1e6a3d2
SA_Business_Payment option UPI b6f5a2c7d9e3
Net banking e3b1c9f7a2d6
Cards f6d2b7c1e9a3
SA_Business_Payement status Done d9e7c6f1b3a2
Pending c1b5f2a9d7e3
Failed e4f7c6b3a2d9
SA_Business_payment status done Bus booked f9b1a6d3c2e5
SA_Business_City name Drop down for state & city d6c8b5e3a1f9
SA_Business_Add category Form to accept vehicials category c7b9e5f3d2a6
SA_Business_Add sub-category Form to accept vehicials sub-category b8d2a1c7e5f9
SA_Business_Add vehicial From to accept the vehicial e2f6b3a1d7c9
Price f7c9d1a8b3e2
SA_Business_Date & Time Calander d1e5f6c9b3a2
Time c9b2e7f1a6d3
SA_Business_Address Map's e5d1f7a2c9b3
SA_Business_Enter address manually Form to accept address b6c5d1a7f9e2
Drop down for state & city f8d3a9c6e1b2
SA_Business_Verify customer Check box for verification d2e1c6f7b9a3
SA_Business_Check bus avalibility Yes c3a2d5b7f9e6
No b9f1e3d2c6a7
SA_Business_Check dates Calander f2c9b7d1a8e3
SA_Business_Pick up point Map's d5c1e3b6f7a2
SA_Business_Enter address manually Form to accept address c8b3e7d1a2f9
Drop down for state & city f9b1a6d2e5c3
SA_Business_Drop point Map's d3c7b9e5a1f6
SA_Business_Enter address manually Form to accept address e1b6c2f5a9d3
 Drop down for state & city b7d5f6c3a1e9
SA_Business_Payment option UPI f3a9b1d7e2c6
Cash d2e1b5c7f9a3
SA_Business_Payement status Done c1b9f7d2e6a3
Pending e6a2f3b9d5c1
SA_Business_payment status done Ride booked f5b7d1e6c3a9
SA_Business_City name Drop down for state & city d7a1b6c9f3e2
SA_Business_Add category Form to accept vehicials category c9f3d5b7a2e1
SA_Business_Add sub-category Form to accept vehicials sub-category e2b6d7f9a3c1
SA_Business_Add vehicial From to accept the vehicial f6b1a7d5c9e2
Price d3c9e7b1f6a2
SA_Business_Date & Time Calander c7f5d2a9b6e1
Time b3e7c1f9d6a2
SA_Business_Address Map's f8b1d9c3a2e7
SA_Business_Enter address manually Form to accept address d9a7e6b3f5c2
Drop down for state & city c2b6f9d1a7e3
SA_Business_Verify customer Check box for verification e7b9d3f1c2a5
SA_Business_Check vehicials avalibility Yes f5c3d7e1b6a9
No d6a9c2f1b7e5
SA_Business_Check dates Calander c1e2b5d7a9f3
SA_Business_Pick up point Map's e5f3d6b9c1a7
SA_Business_Enter address manually Form to accept address f7c1d2e9b5a3
Drop down for state & city d3b6e5f9c1a7
SA_Business_Drop point Map's c2f9b1d7e6a3
SA_Business_Enter address manually Form to accept address b6e2c1d9a7f5
Drop down for state & city f5a7d3c1b9e6
SA_Business_Payment option UPI d7b9f1c2a5e3
Cash c3a2f5d9b7e1
SA_Business_Payement status Done f2d3b1e9c6a7
Pending d1f7b6a9e2c5
SA_Business_payment status done Shifting booked c9e3d7a1b5f2
SA_Business_Theater name Form for theater name f6d2c9a1b3e5
SA_Business_City name Drop down for state & city b3d2f1a7e9c6
SA_Business_Add category based on genres Form to accept category e4a9c2f1d5b7
SA_Business_Add sub-category based on genres Form to accept sub-category f5b1d3e7a9c6
SA_Business_Add movie & Event From to accept the movie and event d2c6b9e5f3a1
Price c7b1e9f3d6a2
SA_Business_Date & Time Calander e3f7c1d2b5a9
Time f2b9d7c1e3a6
SA_Business_Address Map's d6e1b5f9a7c2
SA_Business_Enter address manually Form to accept address c3d9b6e7f1a5
Drop down for state & city f4a6d3c9b7e2
SA_Business_Verify customer Check box for verification d5e9c2b6f1a7
SA_Business_Check seat avalibility Yes c9f1d3a7b5e2
No e1a7c9d2f3b6
SA_Business_Check dates Calander f6b1c5d9a3e2
SA_Business_Theater or Event location Map's d2e3b1f9c7a6
SA_Business_Enter address manually Form to accept address c7f9d5a6b2e1
Drop down for state & city b5d6a3f9c2e1
SA_Business_Payment option UPI f2b7d6e1c3a9
Cash d9c7e5b1f3a6
SA_Business_Payement status Done c1a2e9b7f6d3
Pending e2b5f1d3c9a7
SA_Business_payment status done Movie or Event booked f9a2d5c7b1e3
Docker Image Id's
f3c1e8b7a6d2
b2d6f9a5e7c1
a9c2d3f6b4e7
c8f2d1a6b5e9
d7a3e9c6b1f4
e5f9b2d7c8a3
f6d1e7c9a4b2
a3b7f9d5e1c8
d4e9b1c6a5f2
e6f3d2c8a7b9
b7e1a4f3d9c2
f8b3d7a5e6c1
d9a2e7c1b5f3
c4f8d2a6b9e3
e1b5d6c9f2a7
f5c3a8d9b1e6
b6d9e3a5c7f2
f3a1e8d7c5b9
d6c2f9a7e5b1
e9b6f3a1c5d7
c3d2f7b1a9e5
f4a2e9c6d7b3
b5e3f2a6d7c9
e1a8d4f9b7c2
d9f5c3a7b1e2
a3b9d2e7f5c8
f7c9d1e5b6a3
b1e3f9a7c5d8
e9b7d6c5f2a3
f5c2a6b9d3e1
c8d7f3e9a4b2
b4e2d1f7c9a5
f6a9b3c2d7e1
d1f9e5c8b3a7
c7b6e2f1d3a9
e3a2d5f7b8c9
f1c9b7a5e6d2
d4b2f9c8a3e7
e9b1a5c6f2d3
c6d8f9a1b3e2
b3a9e7d1f2c5
f2d1e9c6b8a7
a6b3e7f1d9c5
d9e7b5c3a2f1
e1c6b9f5d8a2
c2f3d9a5b1e7
b7f2c8a1e3d6
d5b6c9e2a7f3
e9c4a5b7d6f2
c8a1b7f3d5e9
b3f6d9a1e7c2
f2d5a9b7c6e3
d7e2b1c5f3a9
c3a9e7d5b2f6
b8e3d2f7c1a9
f1d5c6b7a9e2
d6b9a3f1e7c2
e4a1b7c2f6d9
c9e7d1b3a5f2
b6f3a9d2c8e1
e2d9b1f7a3c5
f7a9b2d6e5c1
b9c6a7f3d1e2
c4d5f9a2b3e7
e9b3a1d7c2f5
d8b1f6c2e9a7
f5a2c7b9e6d1
c7b6f5d9a1e3
d2a9f6c1e3b7
b7d3f9c2e8a1
f3a6c1b7e5d9
d5c2e9f1a8b7
b8f9a6d1e3c2
e3a7f2d9b6c1
c5d1b9e3a8f7
f1b6c3a7d9e2
d7c9f5b1a2e6
b2e1f3a7c9d5
e8b3f6d1a7c9
f9b2c5a7d3e6
d6c2b1a3f9e7
c1d9b6a7e5f3
e4f9a3b2d7c6
f2c7d5e9b1a6
b9a1c6d7f3e5
d1c9f5b7e8a2
c7a6b9d2f5e1
e5c3d9b7a1f6
f9b2a3d7c6e1
d8e5b1a6f7c9
c2f7b6d3e9a5
b1d2f9e3a7c6
f6b3c7d9a1e2
d5a9e2b7f6c3
c9f5b2d1a3e7
b8c7d1e2f9a6
e1b3f5d9a7c2
c6a9d7b5f2e1
d2e5f3a6b7c9
f1b2d9c3a7e5
b7f5c1a9d6e3
e9b6c1d5a7f3
f5a3b9e1d7c2
d3c9f6b7a1e5
c5e2b9f7a3d1
f8c1b3d7a9e2
d2e3f9c5b7a1
c7b9f1e6a3d2
b6f5a2c7d9e3
e3b1c9f7a2d6
f6d2b7c1e9a3
d9e7c6f1b3a2
c1b5f2a9d7e3
e4f7c6b3a2d9
f9b1a6d3c2e5
d6c8b5e3a1f9
c7b9e5f3d2a6
b8d2a1c7e5f9
e2f6b3a1d7c9
f7c9d1a8b3e2
d1e5f6c9b3a2
c9b2e7f1a6d3
e5d1f7a2c9b3
b6c5d1a7f9e2
f8d3a9c6e1b2
d2e1c6f7b9a3
c3a2d5b7f9e6
b9f1e3d2c6a7
f2c9b7d1a8e3
d5c1e3b6f7a2
c8b3e7d1a2f9
f9b1a6d2e5c3
d3c7b9e5a1f6
e1b6c2f5a9d3
b7d5f6c3a1e9
f3a9b1d7e2c6
d2e1b5c7f9a3
c1b9f7d2e6a3
e6a2f3b9d5c1
f5b7d1e6c3a9
d7a1b6c9f3e2
c9f3d5b7a2e1
e2b6d7f9a3c1
f6b1a7d5c9e2
d3c9e7b1f6a2
c7f5d2a9b6e1
b3e7c1f9d6a2
f8b1d9c3a2e7
d9a7e6b3f5c2
c2b6f9d1a7e3
e7b9d3f1c2a5
f5c3d7e1b6a9
d6a9c2f1b7e5
c1e2b5d7a9f3
e5f3d6b9c1a7
f7c1d2e9b5a3
d3b6e5f9c1a7
c2f9b1d7e6a3
b6e2c1d9a7f5
f5a7d3c1b9e6
d7b9f1c2a5e3
c3a2f5d9b7e1
f2d3b1e9c6a7
d1f7b6a9e2c5
c9e3d7a1b5f2
f6d2c9a1b3e5
b3d2f1a7e9c6
e4a9c2f1d5b7
f5b1d3e7a9c6
d2c6b9e5f3a1
c7b1e9f3d6a2
e3f7c1d2b5a9
f2b9d7c1e3a6
d6e1b5f9a7c2
c3d9b6e7f1a5
f4a6d3c9b7e2
d5e9c2b6f1a7
c9f1d3a7b5e2
e1a7c9d2f3b6
f6b1c5d9a3e2
d2e3b1f9c7a6
c7f9d5a6b2e1
b5d6a3f9c2e1
f2b7d6e1c3a9
d9c7e5b1f3a6
c1a2e9b7f6d3
e2b5f1d3c9a7
f9a2d5c7b1e3
 STATE
state_id PK VARCHAR(10)Autoincrement
state_name VARCHAR(10)

CITY
city_id PK VARCHAR(10)Autoincrement
city_name VARCHAR(20)
state_id FK VARCHAR(10)
state_id
state_name

state_id
state_name
state_id
state_name

event_id
event_name
theater_id
date
time
price

movie_id
subcategory_id
movie_name
theater_id
date
time
price
 BUSINESS

business_id PK VARCHAR(10)Autoincrement
business_name varchar(20)

OWNER_DETAILS
owner_id PK VARCHAR(10)Autoincrement
user_id FK VARCHAR(10)
mobile_no VARCHAR(20)
email VARCHAR(20)
address VARCHAR(20)
owner_full_name VARCHAR(20)
owner_mobile_no VARCHAR(15)
owner_email VARCHAR(20)

SERVICE_CATEGORY
category_id PK VARCHAR(10)Autoincrement
category_name VARCHAR(20)
 WORK_STATUS
status_id PK VARCHAR(10)Autoincrement
work_id FK VARCHAR(10)
status ENUM

SERVICE_CATEGORY
category_id PK VARCHAR(10)Autoincrement
category_name VARCHAR(20)

CUSTOMER_LOCATION
location_id PK VARCHAR(10)Autoincrement
work_id FK VARCHAR(10)
latitude DECIMAL(10,2)
longitude DECIMAL(10,2)
manual_address VARCHAR(100)
map_link VARCHAR(500)

HOTEL
hotel_id PK VARCHAR(10)Autoincrement
hotel_name VARCHAR(20)
address VARCHAR(20)
manual_address VARCHAR(20)
state VARCHAR(20)
city VARCHAR(20)
map_link VARCHAR(20)

ROOMS
room_id PK VARCHAR(10)Autoincrement
hotel_id FK VARCHAR(10)
subcategory_id FK VARCHAR(10)
room_name VARCHAR(20)
price DECIMAL(10,2)
availability_status ENUM

BUS_CATEGORY
category_id PK VARCHAR(10)Autoincrement
category_name VARCHAR(10)

PAYMENT
payment_id PK VARCHAR(10)Autoincrement
booking_id FK VARCHAR(10)
booking_type ENUM
amount DECIMAL(10,2)
payment_method ENUM
payment_status ENUM
 STATE
PK VARCHAR(10)Autoincrement
VARCHAR(10)

STATE
PK VARCHAR(10)Autoincrement
VARCHAR(10)
 STATE
PK VARCHAR(10)Autoincrement
VARCHAR(10)

EVENT
PK VARCHAR(10)Autoincrement
VARCHAR(20)
FK VARCHAR(20)
DATE
TIME
DECIMEL(10,2)

MOVIE
PK VARCHAR(10)Autoincrement
FK VARCHAR(10)
VARCHAR(20)
FK VARCHAR(10)
DATE
TIME
DECIMAL(10,2)
 REGISTER AS A BUSINESS

BUSINESS_DETAILS

business_id PK VARCHAR(10)Autoincrement
business_name VARCHAR(20)
business_field VARCHAR(20)
contact_no VARCHAR(20)
email VARCHAR(20)
address VARCHAR(20)
state VARCHAR(20)
city VARCHAR(20)
owner_full_name VARCHAR(20)
owner_mobile_no VARCHAR(20)
owner_email VARCHAR(20)
user_id FK VARCHAR(10)
owner_id FK VARCHAR(10)

PERSONAL CARE SERVICES

SERVICE_SUB_CATEGORY
subcategory_id PK VARCHAR(10)Autoincrement
category_id FK VARCHAR(10)
subcategory_name VARCHAR(20)
 EMPLOYEE
employee_id PK VARCHAR(10)Autoincrement
employee_name VARCHAR(20)
status ENUM
service_id FK VARCHAR(10)

HOUSE AND OFFICE SERVICES

SERVICE_SUB_CATEGORY
subcategory_id PK VARCHAR(10)Autoincrement
category_id FK VARCHAR(10)
subcategory_name VARCHAR(20)

WORK
work_id PK VARCHAR(10)Autoincrement
customer_id FK VARCHAR(10)
service_id FK VARCHAR(10)
work_description VARCHAR(20)
work_status VARCHAR(20)
state_id FK VARCHAR(10)
city_id FK VARCHAR(10)
longitude DECIMAL(10,8)
latitude DECIMAL(10,8)

TRAVEL AND BOOKING

ROOM_CATEGORY
category_id PK VARCHAR(10)Autoincrement
category_name VARCHAR(20)
 BOOKING
booking_id PK VARCHAR(10)Autoincrement
hotel_id FK VARCHAR(10)
room_id FK VARCHAR(10)
customer_name VARCHAR(20)
check_in DATETIME
check_out DATETIME
payment_status ENUM

BUS_SUB_CATEGORY
subcategory_id PK VARCHAR(10)Autoincrement
category_id FK VARCHAR(10)
subcategory_name VARCHAR(10)

INTERCITY
 CITY
city_id PK VARCHAR(10)Autoincrement
city_name VARCHAR(20)
state_id FK VARCHAR(10)

VEHICL_BOOKING
booking_id PK VARCHAR(10)Autoincrement
vehicle_id FK VARCHAR(10)
customer_name VARCHAR(50)
pickup_point VARCHAR(50)
pickup_state_id FK VARCHAR(10)
pickup_city_id FK VARCHAR(10)
drop_point VARCHAR(50)
drop_state_id VARCHAR(10)
drop_city_id FK VARCHAR(10)
travel_date DATE
travel_time TIME
payment_status ENUM

HOUSESHIFTING

CITY
city_id PK VARCHAR(10)Autoincrement
city_name VARCHAR(20)
state_id FK VARCHAR(10)

HOUSE_SHIFTING_BOOKING
booking_idA PK VARCHAR(10)Autoincrement
vehicle_id FK VARCHAR(10)
customer_name VARCHAR(50)
pickup_point VARCHAR(50)
pickup_state_id FK VARCHAR(10)
pickup_city_id FK VARCHAR(10)
drop_point VARCHAR(50)
drop_state_id VARCHAR(10)
drop_city_id FK VARCHAR(10)
travel_date DATE
travel_time TIME
payment_status ENUM

MOVIE AND EVENT BOOKING

CITY
city_id PK VARCHAR(10)Autoincrement
city_name VARCHAR(20)
state_id FK VARCHAR(10)

MOVIE_CATEGORY
category_id PK VARCHAR(10)Autoincrement
category_name VARCHAR(20)

BOOKING
booking_id PK VARCHAR(10)Autoincrement
customer_name VARCHAR(20)
theater_id FK VARCHAR(10)
movie_id FK VARCHAR(10)
event_id FK VARCHAR(10)
booking_date DATE
booking_time TIME
pickup_point VARCHAR(20)
drop_point VARCHAR(20)
state_id FK VARCHAR(10)
city_id FK VARCHAR(10)
verification_status BOOLEAN
payment_status ENUM
R AS A BUSINESS

VERIFICATION_DETAILS
verification_id
owner_id_proof PK VARCHAR(10)Autoincrement
phone_verified BOOLEAN
email_verified BOOLEAN
business_reg_proof VARCHAR(20)
address_proof VARCHAR(20)
gst_no VARCHAR(20)
iso_certificate VARCHAR(20)
workplace_image LONGBOLB
worker_images_videos LONGBOLB
business_id FK VARCHAR(10)

TERMS_AND_FEES
terms_id PK VARCHAR(10)Autoincrement
business_id FK VARCHAR(10)
terms_and_conditions VARCHAR(100)
onboarding_fees DECIMAL(10,2)
payment_options VARCHAR(100)
digital_signature BLOB

AL CARE SERVICES
s

SERVICES
service_id PK VARCHAR(10)Autoincrement
subcategory_id FK VARCHAR(10)
service_name VARCHAR(20)
price DECIMAL(10,2)
image BOLB
 service_desc VARCHAR(100)
rating INT

ASSIGNED_WORK
assignment_id PK VARCHAR(10)Autoincrement
work_id FK VARCHAR(10)
employee_id FK VARCHAR(10)
status ENUM

ND OFFICE SERVICES

SERVICES
service_id PK VARCHAR(10)Autoincrement
subcategory_id FK VARCHAR(10)
service_name VARCHAR(20)
price DECIMAL(10,2)
image BOLB
service_desc VARCHAR(100)
rating INT

EMPLOYEE
employee_id PK VARCHAR(10)Autoincrement
employee_name VARCHAR(20)
status ENUM
mobile_no VARCHAR(15)
service_id FK VARCHAR(10)

L AND BOOKING

ROOM_SUB_CATEGORY
subcategory_id PK VARCHAR(10)Autoincrement
category_id FK VARCHAR(10)
subcategory_name VARCHAR(20)
 BUSES
bus_id PK VARCHAR(10)Autoincrement
subcategory_id FK VARCHAR(10)
bus_name VARCHAR(20)
price DECIMAL(10,2)
availability_status ENUM
pickup_point VARCHAR(50)
drop_point VARCHAR(50)
travel_date DATE
travel_time TIME
state VARCHAR(20)
city VARCHAR(20)
map_link VARCHAR(50)

INTERCITY
 VEHICLE_CATEGORY
category_id PK VARCHAR(10)Autoincrement
category_name VARCHAR(10)

PAYMENT
payment_id PK VARCHAR(10)Autoincrement
booking_id FK VARCHAR(10)
amount DECIMAL(10,2)
payment_method ENUM
payment_status ENUM

HOUSESHIFTING

VEHICLE_CATEGORY
category_id PK VARCHAR(10)Autoincrement
category_name VARCHAR(10)

PAYMENT
payment_id PK VARCHAR(10)Autoincrement
booking_id FK VARCHAR(10)
amount DECIMAL(10,2)
payment_method ENUM
 payment_status ENUM

OVIE AND EVENT BOOKING

THEATER
theater_id PK VARCHAR(10)Autoincrement
theater_name VARCHAR(20)
state_id VARCHAR(10)
city_id VARCHAR(10)
address VARCHAR(100)
map_link VARCHAR(100)

MOVIE_SUB_CATEGORY
subcategory_id PK VARCHAR(10)Autoincrement
category_id FK VARCHAR(10)
subcategory_name VARCHAR(20)

PAYMENT
payment_id PK VARCHAR(10)Autoincrement
booking_id FK VARCHAR(10)
amount DECIMAL(10,2)
payment_method ENUM
payment_status ENUM
 WORK_DETAILS
work_id PK VARCHAR(10)Autoincrement
customer_name FK VARCHAR(10)
mobile_no VARCHAR(15)
work_description VARCHAR(50)
address VARCHAR(50)
 CUSTOMER
customer_id PK VARCHAR(10)Autoincrement
customer_name VARCHAR(20)
mobile_no VARCHAR(15)

ASSIGNED_WORK
assignment_id PK VARCHAR(10)Autoincrement
work_id FK VARCHAR(10)
employee_id FK VARCHAR(10)
assignment_status ENUM
assigned_time TIMESTAMP
 BUSE_BOOKING
booking_id PK VARCHAR(10)Autoincrement
bus_id FK VARCHAR(10)
pickup_point VARCHAR(20)
drop_point VARCHAR(20)
travel_date DATE
travel_time TIME
payment_status ENUM
 VEHICLE_SUB_CATEGORY
subcategory_id PK VARCHAR(10)Autoincrement
category_id FK VARCHAR(10)
subcategory_name VARCHAR(50)

VEHICL
vehicle_id PK VARCHAR(10)Autoincrement
subcategory_id FK VARCHAR(10)
vehicle_name VARCHAR(50)
price DECIMAL(10,2)
availability_status ENUM
state_id FK VARCHAR(10)
city_id FK VARCHAR(10)
address VARCHAR(100)
map_link VARCHAR(100)

VEHICLE_SUB_CATEGORY
subcategory_id PK VARCHAR(10)Autoincrement
category_id FK VARCHAR(10)
subcategory_name VARCHAR(50)

VEHICL
vehicle_id PK VARCHAR(10)Autoincrement
subcategory_id FK VARCHAR(10)
vehicle_name VARCHAR(50)
price DECIMAL(10,2)
availability_status ENUM
state_id FK VARCHAR(10)
city_id FK VARCHAR(10)
address VARCHAR(100)
map_link VARCHAR(100)