Stable IDs, Not Names: The Missing Pattern in Multi-Tenant Design

Using display names as storage identifiers seems natural but creates a fragile system where renaming breaks data integrity. This article demonstrates a fundamental pattern—immutable UUIDs for internal references, mutable names for display—that any multi-tenant system needs to survive real-world operations like client name changes or promotion from staging to production.