Hacker News new | ask | show | jobs
by jack_squat 1121 days ago
When 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.