The primary key is a unique identifier for a record. The primary key cannot be the same for two records. This field can never be blank.
To set a table’s primary key:
A composite key is a primary key that is comprised of two or more fields. It can also be called a compound or concatenated key.
A foreign key is a field or combination of fields that are related to the primary key of another table.