Strugling to use composite key in schema
How do I represent composite primary key in drizzle way (sqlite) below migration query? I red the docs but failed miserable in trying to implement it.
CREATE TABLE QuestionSetMapping (
SetID INTEGER,
QuestionID INTEGER,
PRIMARY KEY(SetID, QuestionID),
FOREIGN KEY(SetID) REFERENCES QuestionSets(SetID),
FOREIGN KEY(QuestionID) REFERENCES Questions(QuestionID)
);