Question: what is difference between surrogate key and primary key?
Answer: 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. Can be surrogate key or any other unique combination of columns (for example a compound key).