Natural vs surrogate keys on support tables
- by Bugeo
I have read many articles about the battle between natural versus surrogate primary keys.
I agree in the use of surrogate keys to identify records of tables whose contents are created by the user.
But in the case of supporting tables what should I use?
For example, in a hypothetical table "orderStates".
If you use a natural key would have the…