Choose between real-world keys and ID keys - SQL | Zoonk
Choose between real-world keys and ID keys
Compare natural keys, like an email or ISBN, with surrogate keys, like an auto-generated customer_id, and decide why many tables use a separate ID column.