3 ms·
Slap a synthetic key on everything, you probably overestimate how bad it is to have multiple records for "the same thing". Even if it is indeed bad, it's proba
by praptak 3y ago
Slap a synthetic key on everything, you probably overestimate how bad it is to have multiple records for "the same thing".
Even if it is indeed bad, it's probably unrealistic to expect to never let it slip on entry (however good the natural keys might be). Maybe it makes more sense to incorporate deduplication into the design right from the start.
- jack_squat 3y agoWhen you use a surrogate key, you should still put a unique constraint on an alternate key. Multiple records for the same thing is a fundamental problem in a database.