surrogate key
English
Noun
surrogate key (plural surrogate keys)
- (databases) A 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.