🗄️Surrogate Key
Also known as Warehouse Key, Synthetic Key
A made-up ID the warehouse gives each row. It means nothing on its own.
Think of it like
It is like a ticket number at a deli counter. It means nothing about you. It just marks your place.
Example
Lucy is customer 881 in the shop app. In the warehouse she has keys 10452 and 20917, one for each city she lived in.
Why it matters
Type 2 history is not possible without it. Two rows for one customer need two different keys.
Definition
Common mistake
Key takeaways
- 1Made up. The warehouse creates it.
- 2No meaning. Just a number that is unique.
- 3One per version. Each row of history gets its own.