#The only purpose of a surrogate key is to become a unique identifier in the database, such as a delta key, GUID, etc.
The surrogate key has no actual meaning and is used to represent existence. It exists only for data analysis.
##Key
|
Product ID | ##Price##505_92 |
##1987 | 200 | 698_56 |
1256 | 170 | 304_57 |
1898 | 250 | 458_66 |
##110 |
Above, the surrogate key is the Key | table in
Some other examples of surrogate keys -
The above is the detailed content of Surrogate keys in RDBMS. For more information, please follow other related articles on the PHP Chinese website!