3 ms·
From 4 years ago on the linked page: “Some comments in the HN thread seem to confuse the logical referential integrity of the relational model, and the FOREIGN
by supportengineer 3y ago
From 4 years ago on the linked page:
“Some comments in the HN thread seem to confuse the logical referential integrity of the relational model, and the FOREIGN KEY constraint, which is a construct where the database enforces the referential integrity.
We do use tables with ‘id’s and tables referencing those ‘id’s. We do not use FOREIGN KEY constraints in our table definitions.”
- philipsd6 3y agoAs a DBA I feel is this a bit of hand-waving… sure you can say your database model has logical referential integrity: “Parent 1:N Child” but without a referential constraint at the database level it’s just documentation.