Drizzle Team•17mo ago

many-to-may relation

How do i define relation like a post probably has many comments that nested, for example a person can reply to other person's comment,

 export const comments = mysqlTable(
  'comments',{
    id: serial('id').primaryKey(),
    postId: int('post_id'),
    comment: text('content').notNull(),
    authorId: int('author_Id').notNull(),
    parentId: int('parent_id'),
    likes: int('likes').default(0),
  },
  
);

 export const comments = mysqlTable(
  'comments',{
    id: serial('id').primaryKey(),
    postId: int('post_id'),
    comment: text('content').notNull(),
    authorId: int('author_Id').notNull(),
    parentId: int('parent_id'),
    likes: int('likes').default(0),
  },
  
);