Run the SQL below in your Supabase SQL Editor to create the Finance tables. After running, refresh this tab.

-- Finance Centre tables for DriveSQ
-- 1. Student payments (money received from students into DriveSQ)
create table if not exists student_payments (
  id uuid primary key default gen_random_uuid(),
  instructor_id text not null,
  student_name text,
  student_account_id text,
  amount decimal(10,2) not null,
  method text default 'bank_transfer',
  reference text,
  notes text,
  credit_hours decimal(6,2),
  created_at timestamptz default now(),
  created_by text default 'admin'
);
alter table student_payments enable row level security;
create policy "admin_all" on student_payments for all using (true) with check (true);

-- 2. Instructor charges (what instructors owe DriveSQ)
create table if not exists instructor_charges (
  id uuid primary key default gen_random_uuid(),
  instructor_id text not null,
  type text not null default 'referral',
  amount decimal(10,2) not null,
  description text,
  status text not null default 'outstanding',
  settled_amount decimal(10,2) default 0,
  settled_via text,
  referral_id text,
  created_at timestamptz default now(),
  settled_at timestamptz
);
alter table instructor_charges enable row level security;
create policy "admin_all" on instructor_charges for all using (true) with check (true);

-- 3. Instructor payouts (when DriveSQ pays instructors)
create table if not exists instructor_payouts (
  id uuid primary key default gen_random_uuid(),
  instructor_id text not null,
  gross_amount decimal(10,2) not null,
  charges_offset decimal(10,2) default 0,
  net_amount decimal(10,2) not null,
  method text default 'bank_transfer',
  notes text,
  charge_ids jsonb,
  created_at timestamptz default now()
);
alter table instructor_payouts enable row level security;
create policy "admin_all" on instructor_payouts for all using (true) with check (true);

-- 4. Add instructor_pay column to lessons if not present
alter table lessons add column if not exists instructor_pay decimal(10,2);
alter table lessons add column if not exists instructor_pay_settled boolean default false;

Waiting List

Instructor Availability