Excellent analysis! The database really is the ultimate coupling trap for modular monoliths. Your "foreign key trap" advice is spot on, truely. No one wants to be the engineer whose choices are cursed for *years*. Give me UUIDs for simplicity anyday.
Of course it depends on each case too, it's not a silver bullet! The FKs can be necessary within each bounded context and when you really need to have consistency ensured on the DB layer.
Excellent analysis! The database really is the ultimate coupling trap for modular monoliths. Your "foreign key trap" advice is spot on, truely. No one wants to be the engineer whose choices are cursed for *years*. Give me UUIDs for simplicity anyday.
Of course it depends on each case too, it's not a silver bullet! The FKs can be necessary within each bounded context and when you really need to have consistency ensured on the DB layer.
But yes, sometimes we overuse FKs :P