4 ms·
Are we discussing constraints, or keys? The term “foreign key” without the word “constraint” totally changes the meaning.
by supportengineer 3y ago
Are we discussing constraints, or keys? The term “foreign key” without the word “constraint” totally changes the meaning.
- supportengineer 3y agoFrom 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.