Surrogate key

A surrogate key (or synthetic key, pseudokey, entity identifier, factless key, or technical key[citation needed]) in a database is a unique identifier for either an entity in the modeled world or an object in the database. The surrogate key is not derived from application data, unlike a natural (or business) key.[1]

  1. ^ "What is a Surrogate Key? - Definition from Techopedia". Techopedia.com. Retrieved 2020-02-21.