foreign key [database structures] An attribute or set of attributes in one table that match the primary key attributes in another table. Foreign keys and primary keys are used to join tables in a database. Related Terms adds table alternate key ancillary source BLOB CAD staging geodatabase