Sites
| Address | What it is |
|---|---|
| collegepricecheck.com | The main site, for families |
| collegepricecheck.com/advise | The advisor job page and application |
| app.collegepricecheck.com | The advisor dashboard |
| admin.collegepricecheck.com | The admin console: queue, advisors, directory, and team |
| help.collegepricecheck.com | This help center |
| slug.collegepricecheck.com | An advisor's public profile (live only). Also at collegepricecheck.com/advisors/slug. |
Database
You shouldn't need these for routine work. They're here for engineers and for when something goes wrong.
| Table or column | What it holds |
|---|---|
advisors.status | The advisor's stage. See The advisor lifecycle. |
advisors.email, advisors.phone | Private contact info. Email is also how they sign in. |
advisors.calendly_inline | Their booking link |
advisors.submitted_at → live_at | Stage timestamps, set automatically |
advisors.setup_done_at | When they submitted for final check |
advisors.checklist | Which team checklist items are ticked, by whom, and when |
advisors.owner_id | Their owner on the team |
advisors.edit_token | The advisor's private key. Never share it. |
advisor_events | Each advisor's timeline: status changes, checks, notes, and emails |
admin_users | Everyone who can sign in to the console |
advisors.admin_notes is no longer used. Its notes were copied into each advisor's timeline.
Settings
These are environment variables in Vercel. This page lists names only, never values.
| Name | What it does |
|---|---|
ADVISOR_ADMIN_EMAIL | Where team alerts go |
ADVISOR_INTRO_CALL_URL | The intro-call booking link shown to applicants |
SUPABASE_WEBHOOK_SECRET | Authenticates the status webhook |
Emails
Advisor emails come from hello@mail.collegepricecheck.com, and replies go to hello@collegepricecheck.com. The templates are in lib/advisorEmails.ts. The console shows each status email before it's sent.