{"id":473,"date":"2022-08-23T16:50:22","date_gmt":"2022-08-23T15:50:22","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/?page_id=473"},"modified":"2022-08-23T16:51:56","modified_gmt":"2022-08-23T15:51:56","slug":"referential-integrity","status":"publish","type":"page","link":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/referential-integrity\/","title":{"rendered":"Referential Integrity"},"content":{"rendered":"<p><span data-contrast=\"auto\">The value of a primary key in one table has a matching value in the corresponding foreign key of another table.<\/span><\/p>\n<p><span data-contrast=\"auto\">Referential integrity means that relationships between the tables must always be consistent.\u00a0 Any foreign key must agree with the primary key that it is linked to.<\/span><\/p>\n<p><span data-contrast=\"auto\">Any changes to a primary key must be applied to all linked foreign keys.<\/span><\/p>\n<p><b><span data-contrast=\"auto\">If a Pilot ID was changed in the Pilots table, then any records in the Flight table that have the Pilot ID as a foreign key would also be changed<\/span><\/b><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The value of a primary key in one table has a matching value in the corresponding foreign key of another table. Referential integrity means that relationships between the tables must always be consistent.\u00a0 Any foreign key must agree with the primary key that it is linked to. Any changes to a primary key must be [&hellip;]<\/p>\n","protected":false},"author":79984,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-473","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/473","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/users\/79984"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/comments?post=473"}],"version-history":[{"count":2,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/473\/revisions"}],"predecessor-version":[{"id":475,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/473\/revisions\/475"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/media?parent=473"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}