4 ms·
ISTM that primary keys should be completely internal to the DB. You can always add another column with a unique index, if someone lies to you that any particula
by jessaustin 11y ago
ISTM that primary keys should be completely internal to the DB. You can always add another column with a unique index, if someone lies to you that any particular datum is unique. Then when dupes roll in like they usually do, you can just drop the index.
A great frustration of mine in a previous job was that a predecessor had informed the accounting department of internal keys used for a many-to-many relation in the configuration of a process that journalled transactions from the billing system to the accounting system. That meant I could never reconfigure the janky-ass, inefficient way that journaling was set up, because the accountants knew how it should be.