[SQL: create table with many-to-many relationship] #constraint #postgres #many-to-many #sql

db_join_table.sql

// vim: syntax=sql

-- many-to-many relationship needs join table
CREATE TABLE IF NOT EXISTS student_course (
  student_id INTEGER,
  course_id INTEGER,
  PRIMARY KEY (student_id, course_id),
  FOREIGN KEY (student_id) REFERENCES student (id),
  FOREIGN KEY (course_id) REFERENCES course (id) );