Project Shell
ReadyApp Router, TypeScript, Tailwind CSS, shared components, and typed Supabase helpers are in place.
A lightweight CRM for freelance video editors. The codebase now includes authentication screens, typed Supabase clients, a protected workspace, and SQL for row-level-secured CRM tables.
Included in this scaffold
App Router, TypeScript, Tailwind CSS, shared components, and typed Supabase helpers are in place.
Schema SQL covers users, clients, projects, invoices, reminders, indexes, and row-level security.
Add NEXT_PUBLIC_SUPABASE_URL and NEXT_PUBLIC_SUPABASE_ANON_KEY to enable live auth.
Clients
Capture contact info, company details, and relationship notes for each editor's roster.
Projects
Track every job from lead to paid with due dates, value, and client links.
Invoices
Store invoice state, due dates, send timestamps, and payment timestamps per project.
Reminders
Queue follow-ups tied to clients or projects so nothing slips between edits.
The SQL lives in supabase/schema.sql. It creates the CRM tables, indexes, enums, and row-level security policies. The app code mirrors that schema in types/database.ts.
Auth routes
/login, /sign-up, /logout
Protected route
/workspace
Shared folders
/app, /components, /lib, /types
Current gap
Add live Supabase keys to activate auth in production