Mikro-orm Many to Many

mikro-orm-many-to-many.ts

@Entity({
  tableName: 'folders',
})
export class FolderEntity {
  @ManyToMany({
    entity: () => Project,
    pivotEntity: () => VisionProjectsFolderEntity,
    joinColumn: 'folder__id', // this property is important to provide, it is the column where we will go and query the pivot table
  })
  projects = new Collection<Project>(this);
}

@Entity({
  tableName: 'projects',
})    
export class ProjectEntity {
  // defining this side of the relationship is optional, only if we need to retrieve folders through projects
  @ManyToMany({
    entity: () => Folder,
    pivotEntity: () => VisionProjectsFolderEntity,
    joinColumn: 'project__id', // this property is important to provide, it is the column where we will go and query the pivot table
  })
  projects = new Collection<Project>(this);
}
    
@Entity({
  tableName: 'projects_folders',
})
export class ProjectsFoldersEntity extends TransectBaseEntity {
  @ManyToOne({ entity: () => FolderEntity, joinColumn: 'folder__id' })
  folder!: FolderEntity;

  @ManyToOne({ entity: () => Project, joinColumn: 'project__id' })
  project!: Project;
}