New posts in Composite Key

Postgres: How to do Composite keys?

How do I specify unique constraint for multiple columns in MySQL?

MySQL Question - Unique Key Not functioning correctly, or am I misunderstanding?