CREATE TABLE folders (
  id UUID PRIMARY KEY,
  name TEXT NOT NULL,
  slug TEXT UNIQUE,
  custom_domain TEXT,
  branding JSONB DEFAULT '{}'
);

// src/middleware.ts
const host = request.headers.get("host");
const folder = await getFolderByDomain(host);

if (folder) {
  // Rewrite to folder context
  return NextResponse.rewrite(
    new URL(`/workspace/${folder.id}${pathname}`, request.url)
  );
}

CREATE TABLE agencies (
  id UUID PRIMARY KEY,
  name TEXT NOT NULL
);

CREATE TABLE agency_clients (
  agency_id UUID REFERENCES agencies(id),
  folder_id UUID REFERENCES folders(id)
);