We have mentioned that all records need unique identifiers and have used a number of constraints to build that field.

However, PRIMARY KEY does that for us.

That's correct! This automatically requires that the field be unique and that it cannot be empty. A primary key can only be used in one field per table.

Hm. There are a few types of keys, and we want to specify which one we need!