Glossary term
What is foreign key? Meaning for developers
A column that points to the primary key of another table and keeps the link valid.
Learn it properly · SQL & PostgreSQLLesson 1: Joins: Combining TablesPrimary and foreign keys, inner, left, right, full and cross joins with drawn result tables, self joins and the NULL trap in left joins.