Glossary: PostgreSQL for Developers
natural key
A key made from real-world data, such as a product SKU or a customer email. Because such values can change or be missing, it is usually kept as a `UNIQUE` column rather than used as the primary key.
Glossary: PostgreSQL for Developers
A key made from real-world data, such as a product SKU or a customer email. Because such values can change or be missing, it is usually kept as a `UNIQUE` column rather than used as the primary key.