Database Schema Overview

Database Schema Overview

Core entities

Users

Fields reserved for seller and admin operations include:

• slug
• role
• status
• google_id
• avatar_url
• phone
• location_label
• bio
• public_profile_enabled
• last_login_at

Categories

Hierarchical category tree with parent_id, name, slug, and active/sort metadata.

Locations

Hierarchical region/city structure with country_code, region_name, city_name, and slug.

Listings

Primary listing record includes:

• seller ownership via user_id
• taxonomy via category_id and location_id
• SEO URL support via slug
• content fields title, summary, body
• monetization and status fields
• timestamps for publish, expiration, and sold state

Listing images

Multiple image uploads are represented by listing_images with ordering and alt text support.

Abuse reports

Captures listing abuse submissions, reporter identity, reason, detail, and review status.

Ad inventory

• ad_slots
• campaigns
• campaign_ad_slot

This keeps placement inventory configurable rather than hardcoded.

Documentation and feature controls

• docs_pages
• feature_flags

Automation

• automation_drafts

Stores raw machine-ingested draft data pending moderator review.

Listing lifecycle states

Recommended canonical states:

• draft
• pending
• published
• rejected
• expired
• sold

Optional expansion tables

The next schema pass should add:

• listing inquiries
• listing moderation actions/status history
• saved searches
• click/impression event tracking