AdvancedBasic SELECT

Multi-column UNIQUE constraint

The query

SQL

ALTER TABLE project_assignments 
ADD CONSTRAINT unique_assignment UNIQUE (emp_id, project_id);

Tested against PostgreSQL 16

Note

“An employee cannot be assigned to the same project twice, but can have multiple projects, and a project can have multiple employees.