export const questionSchema = pgTable('questions', {
id: serial('id').primaryKey(),
text:...
parentId: integer('parentQuestion').references((): AnyPgColumn => questionSchema.id, { onDelete: 'cascade' }),
})
export const questionsRelations = relations(questionSchema, ({ many, one }) => ({
parentQuestion: one(questionSchema, {
fields: [questionSchema.parentQuestion],
references: [questionSchema.id],
relationName: 'parentQuestion',
}),
subQuestions: many(questionSchema, {
relationName: 'subQuestions',
}),
}))
export const questionSchema = pgTable('questions', {
id: serial('id').primaryKey(),
text:...
parentId: integer('parentQuestion').references((): AnyPgColumn => questionSchema.id, { onDelete: 'cascade' }),
})
export const questionsRelations = relations(questionSchema, ({ many, one }) => ({
parentQuestion: one(questionSchema, {
fields: [questionSchema.parentQuestion],
references: [questionSchema.id],
relationName: 'parentQuestion',
}),
subQuestions: many(questionSchema, {
relationName: 'subQuestions',
}),
}))