Foreign key constraint

The foreign key constraint executes a case where a record in one database table has a reference to another record in the database system. For example, a user profile table that has a default cost center column, which refers to a record in the cost center table. In such cases, cost center defined in the user profile table must be a valid entry in the cost center table.