Term Kind Topic What it is
Foreign Key Constraint concept Relational Modelling A database-enforced rule that a referencing value must exist in the referenced table — referential integrity that no application bug can violate.
Surrogate Key Synthetic Key concept Relational Modelling A system-generated identifier with no business meaning, used as the primary key instead of a naturally occurring business value.