surrogate key

noun

surrogate key

noun
1

Computing, Databases, Engineering, Mathematics, Natural sciences, Physical sciences, Sciences 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.

Entry derived from the Wiktionary, under licence CC BY-SA 4.0 — list of authors.