TypeORM中复合主键导致列重复问题排查

你期望创建classes关联表，用student_id、teacher_id、class_id三个字段同时作为主键和外键，关联user和class_group表，但最终生成了6列，表结构如下：

你的实体代码如下：

@Entity()
export class Classes {
  @PrimaryColumn()
  classId: number;

  @PrimaryColumn()
  studentId: number;

  @PrimaryColumn()
  teacherId: number;

  @ManyToOne(() => User, user => user.classes)
  @JoinColumn({ name: 'student_id' })
  student: User;

  @ManyToOne(() => User, user => user.classes)
  @JoinColumn({ name: 'teacher_id' })
  teacher: User;

  @ManyToOne(() => ClassGroup, classGroup => classGroup.classes)
  @JoinColumn({ name: 'class_id' })
  classGroup: ClassGroup;
}

@Entity()
export class User {
  ...

  @OneToMany(() => Classes, classes => classes.student)
  classes: Classes[];

  @OneToMany(() => Classes, classes => classes.teacher)
  classesAsTeacher: Classes[];
}

@Entity()
export class ClassGroup {
  ...

  @OneToMany(() => Classes, classes => classes.classGroup)
  classes: Classes[];
}

问题原因 #

你同时做了两件事导致字段重复：

1. 手动定义了classId、studentId、teacherId三个主键列；
2. 通过@ManyToOne+@JoinColumn注解，TypeORM自动生成了对应的外键列（student_id、teacher_id、class_id）。

两者叠加就生成了6列，而且Classes中teacher的@ManyToOne关联还错误指向了user.classes，应该对应user.classesAsTeacher，这会导致关联关系逻辑混乱。

解决方法 #

有两种方式可以修正，选其一即可：

方式一：直接在关联上标记主键（推荐）

不需要手动定义主键字段，给@ManyToOne添加{ primary: true }配置，让TypeORM自动将外键列设为联合主键：

@Entity()
export class Classes {
  @ManyToOne(() => User, user => user.classes, { primary: true })
  @JoinColumn({ name: 'student_id' })
  student: User;

  @ManyToOne(() => User, user => user.classesAsTeacher, { primary: true })
  @JoinColumn({ name: 'teacher_id' })
  teacher: User;

  @ManyToOne(() => ClassGroup, classGroup => classGroup.classes, { primary: true })
  @JoinColumn({ name: 'class_id' })
  classGroup: ClassGroup;
}

方式二：复用手动定义的主键作为外键

保留手动定义的主键字段，但确保@JoinColumn关联到已有的主键列，避免自动生成新列：

@Entity()
export class Classes {
  @PrimaryColumn({ name: 'class_id' })
  classId: number;

  @PrimaryColumn({ name: 'student_id' })
  studentId: number;

  @PrimaryColumn({ name: 'teacher_id' })
  teacherId: number;

  @ManyToOne(() => User, user => user.classes)
  @JoinColumn({ name: 'student_id', referencedColumnName: 'id' })
  student: User;

  @ManyToOne(() => User, user => user.classesAsTeacher)
  @JoinColumn({ name: 'teacher_id', referencedColumnName: 'id' })
  teacher: User;

  @ManyToOne(() => ClassGroup, classGroup => classGroup.classes)
  @JoinColumn({ name: 'class_id', referencedColumnName: 'id' })
  classGroup: ClassGroup;
}

两种方式都能让classes表只生成你需要的3列，同时满足联合主键和外键的要求，记得修正teacher关联的指向，保证逻辑正确。

内容的提问来源于stack exchange，提问作者Kardier