What is the difference between surrogate key and primary key?
A surrogate key is a made up value with the sole purpose
of uniquely identifying a row.
Usually, this is represented by an auto incrementing ID.
A primary key is the identifying column or set of
columns of a table. ... MUST be unique for any row
and cannot be NULL .