Surrogate Key

An artificial id column, often AUTO_INCREMENT, used as the primary key instead of a natural key.

When to use

PP 04 Q6 compares it with a Composite Primary Key on a many-to-many table: Option B gives the link table its own synthetic book_author_id.

See PP 04.

Appears in