what is the difference between a primary key constraint and a unique constraint?
A primary key is a unique field on a table but it is special in the sense that the table considers that row as its key. This means that other tables can use this field to create foreign key relationships to themselves. A unique constraint simply means that a particular field must be unique. Primary keys can't be null.