Database

Relational databases

Primary key

A primary key is an identifier that references a column in which each value is unique.

A table can have only one primary key.

A primary key may also be constructed using multiple columns of a table. This type of primary key is called a composite key.

Foreign key

A foreign key is a field within a table that is a primary key in another table.