Architecting and designing
  
Foreign key
A column in a table that matches a primary key column in another table. See Primary Key.
A foreign key is an attribute that appears as a primary key (or part of a primary key) in one entity, and as either a primary key or non-key attribute in another entity (depending on whether or not the relationship between the entities is identifying).