pagerguild/virtual-agent

AI Summary: This issue outlines the foundational task of defining the complete database schema for the application using Drizzle ORM within the `apps/api` service. It involves setting up SQLite for local development, implementing migration tooling, and creating a seed script to populate realistic sample data. This work is critical for enabling all subsequent API features related to tours, gigs, bookings, and riders.

AI Summary: This issue aims to establish the foundational monorepo structure for the project. It involves setting up a Bun + Hono backend and a Next.js (App Router) frontend in separate workspaces, alongside integrating Doppler for secure secrets management from the outset. This comprehensive setup will provide a fully functional end-to-end skeleton, replacing multiple individual scaffolding tasks.