10 ms·
> a service that provides you with a stable id I think there's the important point. Is your key actually natural or is it someone else's surrogate key anyway?
by maweki 2y ago
> a service that provides you with a stable id
I think there's the important point. Is your key actually natural or is it someone else's surrogate key anyway? Going back to the vehicle identification number: that's already a surrogate key. You just did not assign it yourself.
- sgarland 2y agoA VIN is not a surrogate key. A surrogate key must, by definition, have no semantic meaning, and not be composed of parts from multiple domains (among other requirements). A VIN encodes the following: * Country of origin * Manufacturer * Vehicle type * Vehicle model * Engine type * Transmission type * Model year * Manufacturing plant * Serial number