Beginner video - an introduction to primary keys in relational databases. Primary Keys need to be UNIQUE and NOT NULL, but not really anything else. This makes sure that all records are accessible by at least one field (the primary key).
See the code here: http://douglaskline.blogspot.com/2018...