–
Customers
–
Jobs Today
–
Jobs This Week
–
Workers
Today's Jobs
This Week
Viewing as:
Admin PINs
Current PIN hidden for security
Worker PINs
Supabase Connection
📋 Setup Instructions
1
Create a free Supabase account
Go to supabase.com → click "Start your project" → sign in with GitHub. It's 100% free to start.
2
Create a new project
Name it sgy-scheduler, choose a password, select region ap-southeast-2 (Sydney).
3
Create the database tables
Go to SQL Editor in your project and run this SQL:
create table customers (
id uuid primary key default gen_random_uuid(),
first_name text not null,
last_name text not null,
mobile text,
email text,
address text,
suburb text,
service_notes text,
price_notes text,
created_at timestamptz default now()
);
create table workers (
id uuid primary key default gen_random_uuid(),
name text not null,
mobile text,
role text default 'Crew',
active boolean default true,
created_at timestamptz default now()
);
create table jobs (
id uuid primary key default gen_random_uuid(),
customer_id uuid references customers(id) on delete cascade,
service_type text not null,
job_date date not null,
time_start time,
time_end time,
worker_ids text[],
recurrence text default 'once',
notes text,
status text default 'scheduled',
created_at timestamptz default now()
);
4
Get your API keys
Go to Project Settings → API. Copy the Project URL and the anon public key. Paste them in the form above.
5
Enable public access (for now)
Go to Authentication → Policies. For each table (customers, workers, jobs), add a policy: Enable read and write for all users. You can add login later.