← Back to work
DatabaseBackend only

Market Research CMS Database

MySQL schema for multi-site reports, templates, and pricing.

What they needed

A market-research publisher needed a CMS database: multi-site admins, regions/categories, reusable TOC/RD/PR templates, FAQs, scraped sources, and license pricing.

What I delivered

  • MySQL schema (~13 tables) covering websites, admins, regions, reports, templates, pricing
  • ER diagram and developer documentation
  • Sample TOC materials used as content reference

Why it helped

Report content and pricing sit in a normalized model ready for a CMS UI (and later AI-assisted fills) without redesigning storage first.

Tech in the build

MySQL

Access

Backend-only (schema / CMS data model)