QUICKSIR

*Display Business Listings
Show all available business listings added by users in a structured list format.

*Business Detail View
Display complete business information including name, description, contact details, address, and image.

*Search & Filter Businesses
Allow users to search businesses by name and filter them using category, place, district, or state.

*Location-Based Display
Show nearby businesses using location details such as place, district, and pincode.

***Table: business_listings

*id-INT (PK)-Unique business ID

*user_id-INT (FK)-Business owner (user)

*category_id-INT (FK)-Business category

*business_name-VARCHAR-Name of the business

*description-TEXT-Business description

*contact_no-VARCHAR-Contact number

*website-VARCHAR-Business website

*place-VARCHAR-Business location

*state-VARCHAR-State

*district-VARCHAR-District

*pincode-VARCHAR-Area pincode

*latitude-VARCHAR-Latitude

*longitude-VARCHAR-Longitude

*image_url-VARCHAR-Business image

*status-ENUM-active / inactive

*created_at-DATETIME-Business listing created time

*Each record represents one business listed by a user.

*This table is used to populate:

  *Business listing page

  *Business detail page

*Category and location fields support filtering and search.

*Status field controls business visibility.

***Validations

*Only businesses with status = active should be visible to users.

*Each business must be linked to a valid category.

*Business listings must contain mandatory fields (business name, category, location).

*Inactive or deleted business listings must not appear in business view.

*Duplicate business entries by the same user should be avoided.

*Pagination should be applied if the number of businesses is large.

*Business images must be of valid format and size.