What is a primary key? Natural vs surrogate keys.

Primary keys

Primary key uniquely identifies a row. Natural key uses business meaning (email); surrogate uses generated ID (UUID, auto-increment)—stable when natural keys change.

id BIGSERIAL PRIMARY KEY  -- surrogate
UNIQUE (email)              -- business uniqueness