QUICKSIR

Implement ad creation and management functionality for users.
Users should be able to create, view, edit, and manage ads with category and location selection.

***ads_table

id (PK) – Unique identifier for each ad

user_id (FK users.id) – Reference to the user who created the ad

category_id (FK categories.id) – Reference to the selected category

location_id (FK locations.id) – Reference to city/area level location

title – Title of the advertisement

description – Detailed description of the ad

price – Price of the item/service
price_type – Pricing type (fixed / negotiable / free)

condition – Item condition (new / used)

status – Ad status (draft / pending / published / rejected / sold / expired)

reject_reason (nullable) – Reason for rejection (if rejected by admin)

contact_preference – Preferred contact method (chat / call / both)

latitude, longitude (nullable) – Location coordinates for mapping (optional)

published_at – Date and time when the ad is published

expires_at – Date and time when the ad expires

created_at – Ad creation timestamp

updated_at – Last updated timestamp