backend/migrations/003-create_artist_genre_xref.sql

   1 CREATE TABLE ARTIST_GENRE_XREF (
   2   ID INTEGER PRIMARY KEY AUTOINCREMENT,
   3   ARTIST_ID NOT NULL,
   4   GENRE_ID NOT NULL,
   5   UNIQUE(ARTIST_ID, GENRE_ID),
   6   FOREIGN KEY(ARTIST_ID) REFERENCES ARTIST(ID),
   7   FOREIGN KEY(GENRE_ID) REFERENCES GENRE(ID)
   8 );