Jun 12, 2024
This approach dovetails nicely into the idea of designing your data entities as aggregates. One entity (i.e .table) serves as the aggregate root, and is externally addressable by a UUID. The other "subordinate" entities use int/bigint columns to join to their parent aggregate root table.