many-to-many foreign key constraint 787 issue
I cannot add a row in my
likes_to_questions
table even though both user_id
and question_id
are unique, and the primary key is composed of those two, so as to allow a user to have only 1 like on a question
this is my relations
attempting to add a new row (see the picture) will result in error 7872 Replies
* I double checked that
primaryKey
function comes from sqlite adapter
* userId
and questionId
are both primary keys
Not only I cannot add new rows, I cannot edit them either, it throws 787You can't add/edit rows only in drizzle studio? Could you please show your error with error message?