Home >  Term: foreign key
foreign key

In relational databases, an attribute in an entity that gives it access to rows in another entity. This attribute must be the primary key of the related entity. For example, an Employee entity can contain the foreign key deptID , which matches the primary key in the entity Department. You can then use deptID as the source attribute in Employee and as the destination attribute in Department to form a relationship between the entities. See also primary key, relationship.

0 0

Kūrėjas

© 2024 CSOFT International, Ltd.