Multi-tenant real-estate CRM and document portal

Problem

Several companies needed to manage their portfolio and their paperwork on the same installation, without seeing each other’s data and without standing up separate infrastructure for each one.

Decision

Isolate per query, not per installation. That is what lets one small server support several companies, but it means no query can ever be written without its scope: the decision shapes everything else.

Implementation

Query scoping, per-document permissions and separate numbering sequences for each company.

It sits on the aggregator’s data: already-normalised properties feed the portfolio records with no manual re-entry.