Databasesintermediate1 min read

Foreign Key

N/A

外键

Foreign Key · N/A · 外键 · FOR-in kee · FK · referential integrity · Databases · sql · relations · schemaDatabasesFK referential integrity

/FOR-in kee/

Also known as: FK, referential integrity

Last updated August 8, 2026

Definition

A foreign key is a column that references a primary key in another table, enforcing relationships and referential integrity between records.

Real-World Example

An orders table may store customer_id as a foreign key pointing to customers, so every order links to a real customer row.

References

discuss://translation · public

Translation discussion

Anyone can read and write here. Pick a display name — no email or account. Please keep the thread constructive. Thumb up a rendering you agree with — that helps the editor see consensus; it does not publish the term by itself. You can edit or delete your own comments from this browser; another device or cleared site data cannot.

Community lists who wrote, on which term, and when.

Loading discussion…