Surrogate key vs natural key — which should be the primary key?

Answer preview

A natural key is a business-meaningful column that already identifies a row — email, ISBN, SKU, ISO country code. A surrogate key is a system-generated meaningless identifier such as an identity column or UUID. The practical default is a surrogate primary key plus a UNIQUE constr…