The surfaces are built and seeded. The first move isn't a big-bang launch — it's standing them up on staging, connecting them to a real Supabase backend in read-only mode, and putting Errick Jones in the driver's seat so he sees live Custom Image data before anyone can change a thing. Writes come next, gated.
One owner account, read access across the whole platform. Errick can open any surface and see real numbers — enrollment, cohorts, outcomes, funding — without the risk of editing live records while we're still wiring.
Errick drives; the platform is his co-pilot. He logs in once and every surface is his to read — the public site, the applicant pipeline, the instructor and admin views, scheduling, and the accreditation evidence. DRGx builds and runs the engine behind him.
All surfaces deployed behind a single staging index. Private link for Errick & the board to click through.
The marketing site & certificate verify go live on the school's domain — the front door.
Student, instructor, admin, scheduling & accreditation behind login on a subdomain.
Every surface stops using seeded data and starts reading from Supabase. Public surfaces read anonymously; everything else requires Errick's authenticated session. No writes yet — these are read-only views and policies.
| Surface | Reads (Supabase) | Access |
|---|---|---|
| MKT · site | programs, courses, modules | anon read |
| MKT · verify | certificates (code → name, trade, date) | anon read |
| ENR · pipeline | applicants, cohorts, referral_sources | Errick read |
| OPS · admin | students, cohorts, instructors, donations, certificates | Errick read |
| INS · instructor | cohorts, enrollments, sessions, submissions | Errick read |
| APP · student | enrollment, module_progress, sessions | Errick read |
| SCH · scheduling | rooms, equipment, cohort_sessions | Errick read |
| ACC · accreditation | standards, slos, evidence, self_study | Errick read |
Create the project, set the region, capture the URL and anon/service keys into staging env.
supabase init · supabase linkTables for tenants, users, courses, cohorts, enrollments, sessions, submissions, certificates, donations, standards, evidence. Plus read-friendly views the surfaces query.
supabase db pushLoad Custom Image's six trades & real curriculum; import the first real cohorts, instructors & any existing records.
seed.sql · curriculum + cohortsEnable row-level security; grant select to anon on public tables and to authenticated (Errick's owner role) on the rest. No insert/update/delete policies yet.
policy: select for role = ownerSwap each app's seeded state for a read fetch. Public surfaces use the anon client; the apps use Errick's session.
supabase.from(view).select()Provision Errick's owner login, deploy to staging, and click every surface to confirm the live numbers read true.
smoke test · all surfaces