Hacker News new | ask | show | jobs
by clavalle 3725 days ago
There is no way to enforce data integrity between related tables by virtue of the data model for one thing.
3 comments

I don't get this argument. Foreign key constraints are part of the schema.

What should the primary key be if not a UUID?

A natural key. It is not always possible, but when it is it should be used.
an integer id?
isn't that what the fk are for? food_uuid for example. I concede I wouldn't call it uuid but I don't see a problem keeping the data straight.
?? foreign keys?