Realtime ConveyancerNational platform foundations
Both firms are in the same table.
One relation, read three ways: as Firm A, as Firm B, and with the tenant policy bypassed. Every reading leads with ctid, the physical address of the row, so the same row can be found in two of them and shown to be the same row rather than a similar one. The unfiltered reading adds one column the others cannot have — the tenant each row belongs to.