Stack

Routing

The frontend uses hash-based routing (React state, no React Router):

Sign out reloads the page (window.location.reload()), which drops hash state and returns to the public site.

Key Files

Database Schema

All tables are in Cloudflare D1 (contractor_db, UUID: 5f5efd19-3979-4c1b-a75c-ebd9e2256736). Results are flat — no nested joins.

settings

CREATE TABLE settings (
  key   TEXT PRIMARY KEY,
  value TEXT
);

Key rows:

clients

CREATE TABLE clients (
  id         INTEGER PRIMARY KEY,
  name       TEXT NOT NULL,
  email      TEXT,
  phone      TEXT,
  address    TEXT,
  created_at TEXT DEFAULT CURRENT_TIMESTAMP
);

service_requests

CREATE TABLE service_requests (
  id             INTEGER PRIMARY KEY,
  name           TEXT NOT NULL,
  email          TEXT,
  phone          TEXT,
  service_type   TEXT,
  service_address TEXT,
  preferred_date TEXT,
  notes          TEXT,
  status         TEXT DEFAULT 'New',
  created_at     TEXT DEFAULT CURRENT_TIMESTAMP
);

jobs

CREATE TABLE jobs (
  id             INTEGER PRIMARY KEY,
  client_id      INTEGER REFERENCES clients(id),
  service_type   TEXT,
  scheduled_date TEXT,
  scheduled_time TEXT,
  address        TEXT,
  labor_cents    INTEGER DEFAULT 0,
  material_cents INTEGER DEFAULT 0,
  status         TEXT DEFAULT 'Scheduled',
  recurrence     TEXT DEFAULT 'none',
  notes          TEXT,
  created_at     TEXT DEFAULT CURRENT_TIMESTAMP
);

estimates

CREATE TABLE estimates (
  id          INTEGER PRIMARY KEY,
  client_id   INTEGER REFERENCES clients(id),
  line_items  TEXT,   -- JSON array of {description, qty, unit_price}
  total_cents INTEGER DEFAULT 0,
  status      TEXT DEFAULT 'Draft',
  notes       TEXT,
  created_at  TEXT DEFAULT CURRENT_TIMESTAMP
);

invoices

CREATE TABLE invoices (
  id           INTEGER PRIMARY KEY,
  client_id    INTEGER REFERENCES clients(id),
  line_items   TEXT,   -- JSON array of {description, qty, unit_price}
  amount_cents INTEGER DEFAULT 0,
  status       TEXT DEFAULT 'Draft',
  notes        TEXT,
  created_at   TEXT DEFAULT CURRENT_TIMESTAMP
);

appointments

CREATE TABLE appointments (
  id                   INTEGER PRIMARY KEY,
  client_id            INTEGER REFERENCES clients(id),
  service_request_id   INTEGER,
  title                TEXT NOT NULL,
  service_type         TEXT DEFAULT '',
  scheduled_date       TEXT,
  scheduled_time       TEXT DEFAULT '09:00',
  duration_minutes     INTEGER DEFAULT 60,
  address              TEXT DEFAULT '',
  assigned_contractor  TEXT DEFAULT '',
  notes                TEXT DEFAULT '',
  status               TEXT DEFAULT 'Scheduled',
  -- Recurring fields (added via migrations 0006 + 0007):
  recurring            INTEGER DEFAULT 0,           -- 0 = one-off, 1 = recurring
  recurrence           TEXT DEFAULT '',             -- Daily | Weekly | Bi-Weekly | Monthly | Custom Weekdays
  recurring_end_date   TEXT DEFAULT '',             -- YYYY-MM-DD, optional
  recurring_days       TEXT DEFAULT '[]',           -- JSON array of day indices [0=Sun … 6=Sat]
  created_at           TEXT DEFAULT CURRENT_TIMESTAMP,
  updated_at           TEXT DEFAULT CURRENT_TIMESTAMP
);

Recurrence options: Daily, Weekly, Bi-Weekly, Monthly, Custom Weekdays. When "Custom Weekdays" is selected, recurring_days holds a JSON array such as [1,3,5] (Mon, Wed, Fri). The UI renders a weekday button-picker (Sun Mon Tue Wed Thu Fri Sat).

employees

CREATE TABLE employees (
  id         INTEGER PRIMARY KEY,
  name       TEXT NOT NULL,
  phone      TEXT,
  pin_hash   TEXT,
  created_at TEXT DEFAULT CURRENT_TIMESTAMP
);

API Routes

All routes are on the Worker at buildright-api.sonandigital.com. Admin routes require a Authorization: Bearer <jwt> header.

Auth

Employee PINs use the same PBKDF2 hash. PINs are 4 digits. After hashing, the plaintext PIN is never stored.

Known Gotchas