undefined | Better HN

0 pointsclavalle10y ago0 comments

There is no way to enforce data integrity between related tables by virtue of the data model for one thing.

0 comments

5 comments · 3 top-level

gcr10y ago· 2 in thread

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

What should the primary key be if not a UUID?

clavalleOP10y ago

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?

j / k navigate · click thread line to collapse