surrogate key
surrogate key · surrogate keys
A unique identifier for an entity or object, not derived from application dataA unique identifier for an entity or object, not derived from application data.
Meaning
1 sensesA unique identifier for an entity or object, not derived from application data.
We weren't sure which columns in the table would have unique values, so we used a separate surrogate key as the primary key.
Forms
plural: surrogate keys| Singular | surrogate key |
|---|---|
| Plural | surrogate keys |
regular