And then, don't just drop the constraints because you read an article about how FK constraints don't work with a distributed relational model, take a careful lo

And then, don't just drop the constraints because you read an article about how FK constraints don't work with a distributed relational model, take a careful look at the docs of whatever DB engine you're using. PostgreSQL 12 for example supports foreign keys with either side being a partitioned table.