Nicolas Perronblogdev.ca·Apr 23, 2023Doit-on utiliser les clés de substitut (Surrogate keys)?L’utilisation de clés de substitut (Surrogate keys) est très utile afin d’éviter de propager la clé logique dans d’autres tables en tant que clés étrangères (Foreign key). Le but est de pouvoir modifier la clé de la table sans avoir à faire des man...95 readssurrogate key
Tiffany Chongblog.sciffany.com·Jan 25, 2023Primary Key vs Surrogate Key When Working with 3rd Party DatabaseAt our company, we use Prisma relational database, and we work with information from a third-party database, something similar to Twitter or Reddit. Let's use Twitter as an example for this blog. And our decision was how to model our "User" and "Twee...1 like·76 readsDatabases