A primary key built from two or more columns, used when no single column is unique on its own.
CREATE TABLE enrollment ( student_id INT, course_id INT, PRIMARY KEY (student_id, course_id) );