Skip to content

Provision Neon Postgres + schema + migrations #9

Description

@quinn-dougherty

Description

Foundation for every form and admin view. Provision Neon via Vercel Marketplace, pick an ORM, write migrations for the schema in PLAYBOOK.md §2.

Requirements

  • Install Neon from Vercel Marketplace — auto-provisions `DATABASE_URL`.
  • Pick ORM: Drizzle or Prisma. Don't re-litigate. Playbook suggests Drizzle.
  • Initial tables (see PLAYBOOK.md §2 for full columns):
    • `curators`, `curator_apps`
    • `submissions`, `submission_reviews`
    • `registrants`
    • `schedule_slots`
    • `audit_log`
  • All tables: `created_at`, `updated_at`; soft-delete only if needed.
  • Unique index on `registrants.stripe_session_id` (idempotency for webhook).
  • Confirm Neon PITR backups are enabled.

Dependencies

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions