Re:The problem with invariants is that they change over time
by CodesInChaos on Tuesday April 23, 2024 @12:21PM
(#40133739)
I almost always use surrogate keys as primary keys (or a tuple of them, for join-tables). Natural keys are rarely as immutable and unique as we'd like.
Even ISO country codes can be problematic, for example we currently use XK for Kosovo, but it might get an official code at some point.
Even ISO country codes can be problematic, for example we currently use XK for Kosovo, but it might get an official code at some point.