Platform

MODEL REGISTRY 4 models · routed per task class

INTEGRATION FABRIC 17 connectors · OAuth2 / API key / partner creds

ROUTING RULES 20 task classes

PERSISTENCE LAYER PostgreSQL 16 · JSONB payloads · row-level security

-- core entities (Postgres 16, schema_version: 0.4)
CREATE TABLE agents (
    id          UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    slug        TEXT UNIQUE NOT NULL,
    name        TEXT NOT NULL,
    tier        TEXT NOT NULL,           -- sales | rentals | marketing | admin
    primary_model  TEXT NOT NULL,
    fallback_model TEXT,
    is_active   BOOLEAN DEFAULT true,
    created_at  TIMESTAMPTZ DEFAULT now()
);

CREATE TABLE tasks (
    id           UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    agent_id     UUID REFERENCES agents(id),
    task_class   TEXT NOT NULL,          -- routes through ai_router
    status       TEXT NOT NULL,          -- queued|running|awaiting_approval|done|failed
    payload      JSONB NOT NULL,
    model_used   TEXT,
    latency_ms   INT,
    tokens_in    INT,
    tokens_out   INT,
    created_at   TIMESTAMPTZ DEFAULT now(),
    completed_at TIMESTAMPTZ,
    sla_breach   BOOLEAN DEFAULT false
);
CREATE INDEX tasks_status_idx ON tasks(status) WHERE status IN ('queued','running');
CREATE INDEX tasks_sla_idx    ON tasks(sla_breach) WHERE sla_breach;

CREATE TABLE properties (
    id            UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    address_line  TEXT NOT NULL,
    suburb        TEXT NOT NULL,
    postcode      TEXT NOT NULL,
    type          TEXT NOT NULL,          -- house | apartment | townhouse
    listing_type  TEXT,                   -- sale | rental | both | off_market
    bedrooms      SMALLINT,
    bathrooms     SMALLINT,
    parking       SMALLINT,
    external_ids  JSONB                   -- {agentbox, rea, domain, propertyme}
);
CREATE INDEX properties_suburb_idx ON properties(suburb);

CREATE TABLE approvals (
    id          UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    task_id     UUID REFERENCES tasks(id),
    kind        TEXT NOT NULL,           -- tenant_select | price_change | trust_disburse | offer_accept
    priority    SMALLINT NOT NULL,        -- 1 highest
    raised_at   TIMESTAMPTZ DEFAULT now(),
    decided_at  TIMESTAMPTZ,
    decided_by  TEXT,
    outcome     TEXT
);

ROLLOUT staged over 20 weeks

HUMAN APPROVAL BOUNDARIES non-negotiable · regulated decisions stay with people