🗄️Natural Key
Also known as Business Key, Domain Key
An ID that comes from the real world or the source, like an email address.
Think of it like
It is like your name on a school list. It comes from you, not from the school.
Example
A shop's product table uses codes like TSH-RED-M as the natural key. The warehouse adds a plain number as the surrogate key and keeps the code too.
Why it matters
It is how rows from the source are matched to rows in the warehouse. Lose it, and you cannot trace a row back.
Definition
Common mistake
Key takeaways
- 1From the source. Not made up by the warehouse.
- 2Has meaning. People can read it.
- 3Can change. So keep a surrogate beside it.