PLATFORM ARCHITECTURE

Built for scale.
Designed for simplicity.

The PropTech platform architecture powering multifamily real estate operations. A single PostgreSQL database, unified authentication, a common AI gateway, and a 60+ field property data model shared across every application.

31+
Database Models
5
Applications
8
Permission Roles
60+
Property Fields

The shared data layer powers everything

Every application reads and writes to the same PostgreSQL database, separated by schema prefixes. Property data created in UnitStacks is instantly available to TransitionTrack, PostFolio, Tidua, CampusIQ, and Quorum.

UnitStacks Core
PostgreSQL · 31+ Models
TransitionTrack
PostFolio
Tidua
CampusIQ
Quorum

Schema-separated namespaces (public.*, tt.*, pf.*, tidua.*, campusiq.*) keep application data clean while sharing the same auth, property, and organization records.

Six pillars of the UnitStacks platform

Infrastructure capabilities shared across every application in the ecosystem.

Auth & SSO

Supabase Auth with Microsoft Entra ID (Azure AD) as the identity provider. A single sign-on session works across every application. No separate logins, no password fatigue.

8-Role RBAC

OrgOwner, OrgAdmin, PropertyManager, RegionalManager, MaintenanceTech, Leasing, Accounting, and Viewer. Row-level security enforces org isolation at the database layer — not just the API.

AI Gateway

Centralized access to OpenAI GPT-4o and Anthropic Claude. Applications consume AI capabilities through a unified routing layer. Configuration, rate limits, and model selection are managed in one place.

Document Vault

Secure file storage backed by Supabase Storage. Leases, inspection reports, compliance certificates, and marketing assets — all linked to their property record, indexed, and auditable.

Integration Framework

Webhooks, Microsoft Graph API, Meta Business API, and IPEDS data pipelines built in. The platform is designed to connect to your existing property management and investment workflows.

Audit Logging

Every state change across every application generates an immutable audit record. Who changed what, when, from which module. Full traceability for compliance, disputes, and portfolio reviews.

60+ fields per property. Complete portfolio intelligence.

The UnitStacks Property model is the master record for all property data in the ecosystem. Every application reads from it. Every integration writes to it.

Physical
name
address
city / state / zip
unitCount
yearBuilt
squareFootage
propertyType
floors
constructionType
parkingSpaces
Financial
purchasePrice
currentValue
grossRevenue
netOperatingIncome
capRate
debtBalance
loanMaturityDate
annualBudget
ytdExpenses
budgetVariance
Operational
occupancyRate
availableUnits
avgRent
leaseExpirationDate
maintenanceScore
openWorkOrders
propertyManager
managementCompany
onboardingStatus
lastInspection
Compliance
licenseNumber
licenseExpiry
insuranceExpiry
hvacsLastService
elevatorCertExpiry
fireInspectionDate
accessibilityScore
complianceFlags
riskLevel
auditHistory
Unit Lease Tenant WorkOrder Document Inspection BudgetLine Transaction MaintenanceRequest ComplianceRecord OrganizationMember AuditLog

Everything in your portfolio, at a glance

The UnitStacks dashboard aggregates live data from every connected application. KPIs, lease pipeline, budget variance, and smart alerts — always current, always actionable.

app.unitstacks.com/dashboard
Portfolio Units
2,847
▲ +120 this quarter
Occupancy Rate
94.2%
▲ +1.3pts MoM
Monthly Revenue
$4.1M
▼ −2.1% vs budget
Open Work Orders
38
▼ −14 since last week
Lease Expiry Pipeline
Pineview Commons Expires Mar 31 Urgent
Lakeside Terrace B Expires Apr 15 Soon
Northgate Student Housing Expires Apr 30 Soon
Riverside Plaza Expires Jun 1 On Track
Summit Ridge Apts Expires Jun 15 On Track
Smart Alerts
🔴
Insurance renewal overdue — Pineview Commons
2 hours ago · Tidua
🟡
Budget variance −12% at Lakeside B — review flagged
5 hours ago · UnitStacks
🔵
Transition milestone completed — Summit Ridge
Yesterday · TransitionTrack
🟢
3 new social posts published for Northgate
Yesterday · PostFolio

Five modules today.
More tomorrow.

"The UnitStacks platform is designed to host an expanding ecosystem of applications. The shared data layer means every new application instantly benefits from your existing property data, user permissions, and AI configuration — on day one."

TransitionTrack

M&A due diligence and property onboarding. Shares property records and user auth with the platform.

PostFolio

AI-generated social content tied directly to property data — address, amenities, occupancy.

Tidua

Document audit and lease classification. Compliance findings are linked to the property record.

CampusIQ

University enrollment and student housing market intelligence. Geo-tagged to your portfolio.

Quorum

Executive operations overview. Cross-application KPIs surfaced from the shared data layer.

Enterprise-grade security at every layer

Security is not an afterthought. It is built into the architecture from the database up.

Row-Level Security

PostgreSQL RLS policies on all 23 public schema tables. Org isolation enforced at the database layer via public.get_user_org_ids(). No application-layer bypass possible.

AES-256-GCM Encryption

Sensitive fields encrypted at rest using AES-256-GCM. Supabase Vault for secret management. TLS 1.3 in transit. Database backups are encrypted before leaving the region.

Microsoft SSO Only

Email and password authentication has been removed. All access goes through Microsoft Entra ID. Domain restriction via ALLOWED_EMAIL_DOMAINS env. Only approved organizations can access the platform.

Rate Limiting

100 requests per minute per IP across all services. Express rate-limit for Node.js applications. SlowAPI for Python (FastAPI) services. Brute-force and scraping attacks are blocked at the API layer.

Domain Restriction

Authentication callbacks validate email domains against an allow-list. Users from unapproved domains are rejected before a session is created. Fully configurable per deployment environment.

Immutable Audit Trails

Every write operation across every application creates an append-only audit record. Actor, timestamp, resource, and delta. Non-repudiable, exportable, and linked to individual user sessions.

See the applications built
on this platform

TransitionTrack, PostFolio, Tidua, CampusIQ, and Quorum — each purpose-built for a different workflow, all sharing the same foundation.