4 ms·
> If you received a piece of information from an external source, it is data, not a surrogate key. It may not be your surrogate key, but it is someone's!
by randomdata 2y ago
> If you received a piece of information from an external source, it is data, not a surrogate key.
It may not be your surrogate key, but it is someone's!
- shkkmo 2y agoPossibly, you don't actually know since it is external data.
- randomdata 2y agoWe do know because the database owner has openly talked about how the keys are derived. That still doesn't make it a good key for your database, but I can assure you that the world doesn't revolve around you. It is someone's surrogate key – therefore it is a surrogate key.
- shkkmo 2y agoYou seem to be insisting on a semantic interpretation that makes the term less useful. A third party's surrogate key should not be considered a surrogate key when in your system. It doesn't matter how that key was generated, only that the semantic meaning of the key is outside of your control.