database architecture

Key Ingredients: A Guide to Primary, Foreign, Natural, and Synthetic Keys Done Right

Aaron Wise

Use natural keys for real-world uniqueness, synthetic keys for abstraction, and avoid logic in primary keys.