System

Audit log

Every meaningful change captured immutably. Phase 1 wires this to the Supabase audit_log table — append-only at the database level, no UPDATE or DELETE permitted on rows.

Source

Live (Supabase)

Events shown

Distinct actions

Most recent

27 Apr

Activity

Consulted advisor
Profitability advisor opened on Oyra with imported live data — pre-launch hedging applied.
Daniel Johnsonadvisor.profitability
27 Apr 2026, 10:00 pm
Imported live data
Imported Oyra admin export · 7 streams · 0 active revenue (pre-launch).
Daniel Johnsonentity.live_data:ludema
```
after:  {"revenueStreams":7,"activeRevenueAud":0,"coachPayouts":0,"monthlyCostsAud":480}
```
27 Apr 2026, 8:00 pm
Saved scenario
What-if: bought out Harley's 50% of Spokespot.
Daniel Johnsonscenario.snapshot:snap-spokespot-buyout
26 Apr 2026, 4:00 pm
Completed obligation
obligation
Daniel Johnsonobligation:ob-asic-ar-spokespot
25 Apr 2026, 10:00 am
Consulted advisor
Cash advisor — runway across the group with BHP fortnightly modelled in.
Daniel Johnsonadvisor.cash
24 Apr 2026, 6:00 pm
Added entity (sandbox)
Sandbox: prospective NewCo Pty Ltd to hold web-dev contracts.
Daniel Johnsonstructure.entity:sandbox-newco
```
after:  {"name":"NewCo Pty Ltd","type":"pty_ltd"}
```
24 Apr 2026, 2:00 pm
Recorded dissent
Disagreed with Risk Consult re: PI insurance level for first web-dev project — noted reasoning for future review.
Daniel Johnsondissent.entry
23 Apr 2026, 6:00 am
Consulted advisor
Asked accountant agent about gross-revenue model + 47% no-ABN withholding for AU coaches.
Daniel Johnsonadvisor.accounting
22 Apr 2026, 8:00 pm
Edited ownership
Edited proposed ownership of HoldCo from 100% to 60/40 with trust.
Daniel Johnsonstructure.ownership
```
before: {"holdco":"100% Daniel"}
after:  {"holdco":"60% Daniel · 40% Family Trust"}
```
21 Apr 2026, 12:00 pm
Uploaded patent
Provisional spec attached — locking mechanism v2.
Daniel Johnsonip.patent:spokespot-locking-mechanism
19 Apr 2026, 10:00 pm

Action mix

Consulted advisor3

Imported live data1

Saved scenario1

Completed obligation1

Added entity (sandbox)1

Recorded dissent1

Edited ownership1

Uploaded patent1

Schema · helm/supabase/migrations/0001_audit_log.sql

The audit_log table revokes UPDATE and DELETE from every role at the database level — once a row lands, it's permanent. Row-level security restricts SELECT to the authenticated user's own events, with service_role access for back-office reporting.