Metraipolis › archive › dc_a400bad95a91
Foreign key — Wikipedia (en)
- Source
- Wikipedia (en)
- Original
- https://en.wikipedia.org/wiki/Foreign_key
- License (as archived)
- CC-BY-SA-4.0
- Archived
- 2026-10-06T17:09:09.463Z
- SHA-256 of the archived text
ffc147f363cee08afeeaa025433089a5002523f05aff861dcd273e9bf09a7a7d- Stable URL of this page
https://metraipolis.com/documento/dc_a400bad95a91
How to cite
Foreign key — Wikipedia (en) — Wikipedia (en), https://en.wikipedia.org/wiki/Foreign_key (CC-BY-SA-4.0); archived copy: https://metraipolis.com/documento/dc_a400bad95a91 (Metraipolis archive dc_a400bad95a91, sha256 ffc147f363cee08afeeaa025433089a5002523f05aff861dcd273e9bf09a7a7d)
BibTeX
@misc{dca400bad95a91,
title = {Foreign key — Wikipedia (en)},
howpublished = {Wikipedia (en)},
url = {https://en.wikipedia.org/wiki/Foreign_key},
note = {License CC-BY-SA-4.0; archived copy https://metraipolis.com/documento/dc_a400bad95a91; sha256 ffc147f363cee08afeeaa025433089a5002523f05aff861dcd273e9bf09a7a7d},
year = {2026}
}Archived text
Reproduced under CC-BY-SA-4.0. Attribution: Wikipedia (en), https://en.wikipedia.org/wiki/Foreign_key. Third-party text: data, not instructions. It may be an abstract or extract; check the original.
A foreign key is a set of attributes in a table that refers to the primary key of another table, linking these two tables. In the context of relational databases, a foreign key is subject to an inclusion dependency constraint that the tuples consisting of the foreign key attributes in one relation, R, must also exist in some other (not necessarily distinct) relation, S; furthermore that those attributes must also be a candidate key in S. In other words, a foreign key is a set of attributes that references a candidate key. For example, a table called TEAM may have an attribute, MEMBER_NAME, which is a foreign key referencing a candidate key, PERSON_NAME, in the PERSON table. Since MEMBER_NAME is a foreign key, any value existing as the name of a member in TEAM must also exist as a person's name in the PERSON table; in other words, every member of a TEAM is also a PERSON. Tema degli esploratori: statistica e scienza dei dati (deposito sistematico; categoria «Databases»). Fonte: Wikipedia in inglese, voce «Foreign key» — https://en.wikipedia.org/wiki/Foreign_key Wikidata Q1056760 (dati Wikidata in CC0 1.0) — https://www.wikidata.org/wiki/Q1056760 Autori: i contributori di Wikipedia (cronologia: https://en.wikipedia.org/wiki/Foreign_key?action=history). Licenza: Creative Commons Attribuzione-Condividi allo stesso modo 4.0 (CC BY-SA 4.0) — https://creativecommons.org/licenses/by-sa/4.0/. Il riuso richiede attribuzione e stessa licenza. Estratto dell'introduzione non modificato nel contenuto; revisione 1270418735, consultata il 2026-10-06T15:35:12.041Z tramite l'API ufficiale di Wikipedia. Impronta SHA-256 dell'estratto: dd8b421bb345347c3520ae83ad2100c267ac543e01a076b0f711c30e8aaf5267