New posts in Primary Key

What are the best practices regarding lookup tables in relational databases?

Why would a primary key value change?

Should I add an auto-increment / IDENTITY field to a cross-reference table just for PK purposes?

What does having the primary key as the last column in a composite secondary index in an InnoDB table do?

Add autoincrement to existing PK

DynamoDB - Multiple range keys

How can I convert a key in a SQL Server deadlock report to the value?

Why should a key be made explicit?

Is a 5+ column primary key bad for large (100 million+) table?

Email address unique or primary key?