3 replies

many-to-many foreign key constraint 787 issue

I cannot add a row in my

likes_to_questions

likes_to_questions

table even though both

user_id

user_id

and

question_id

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

// 📃 LIKES TO QUESTIONS

export const likesToQuestionsTable = sqliteTable(
  'likes_to_questions',
  {
    userId: text('user_id')
      .notNull()
      .references(() => usersTable.id, { onDelete: 'cascade' }),
    questionId: text('question_id')
      .notNull()
      .references(() => questionsTable.id, { onDelete: 'cascade' }),
  },
  (t) => ({
    pk: primaryKey({ columns: [t.userId, t.questionId] }),
  })
)

// 📃 LIKES TO QUESTIONS

export const likesToQuestionsTable = sqliteTable(
  'likes_to_questions',
  {
    userId: text('user_id')
      .notNull()
      .references(() => usersTable.id, { onDelete: 'cascade' }),
    questionId: text('question_id')
      .notNull()
      .references(() => questionsTable.id, { onDelete: 'cascade' }),
  },
  (t) => ({
    pk: primaryKey({ columns: [t.userId, t.questionId] }),
  })
)

attempting to add a new row (see the picture) will result in error 787

Drizzle Team•2y ago•

3 replies

piscopancer

many-to-many foreign key constraint 787 issue

I cannot add a row in my

likes_to_questions

likes_to_questions

table even though both

user_id

user_id

and

question_id

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

// 📃 LIKES TO QUESTIONS

export const likesToQuestionsTable = sqliteTable(
  'likes_to_questions',
  {
    userId: text('user_id')
      .notNull()
      .references(() => usersTable.id, { onDelete: 'cascade' }),
    questionId: text('question_id')
      .notNull()
      .references(() => questionsTable.id, { onDelete: 'cascade' }),
  },
  (t) => ({
    pk: primaryKey({ columns: [t.userId, t.questionId] }),
  })
)

// 📃 LIKES TO QUESTIONS

export const likesToQuestionsTable = sqliteTable(
  'likes_to_questions',
  {
    userId: text('user_id')
      .notNull()
      .references(() => usersTable.id, { onDelete: 'cascade' }),
    questionId: text('question_id')
      .notNull()
      .references(() => questionsTable.id, { onDelete: 'cascade' }),
  },
  (t) => ({
    pk: primaryKey({ columns: [t.userId, t.questionId] }),
  })
)

attempting to add a new row (see the picture) will result in error 787

many-to-many foreign key constraint 787 issue

Similar Threads

many-to-many foreign key constraint 787 issue

Similar Threads

Similar Threads

Similar Threads