QueryFailedError: there is no unique constraint matching given keys for referenced table “aaa“

保存Error during migration run:时报错

QueryFailedError: there is no unique constraint matching given keys for  referenced table "aaa"

原因是因为

引用表“aaa”没有与给定键匹配的唯一约束

 query: 'ALTER TABLE "gacha_ticket_history" ADD CONSTRAINT "FK_44b678b61fd788438477cfA6deD" FOREIGN KEY ("aaa_id") REFERENCES "aaa"("aaa_id") ON DELETE NO ACTION ON UPDATE NO ACTION',

  // @JoinColumn([{ name: 'aaa_id', referencedColumnName: 'aaaId' }])

改为

  @JoinColumn([

    { name: 'aaa_id', referencedColumnName: 'aaaId' },

    { name: 'app_id', referencedColumnName: 'appId' },

 /** aaa */

  @ManyToOne(() => Aaa, (aaa) => aaa.orderInfo, {

    nullable: true,

    lazy: true,

  })

  // @JoinColumn([{ name: 'aaa_id', referencedColumnName: 'aaaId' }])

  @JoinColumn([

    { name: 'aaa_id', referencedColumnName: 'aaaId' },

    { name: 'app_id', referencedColumnName: 'appId' },

  ])

  aaa?: Aaa;

============ ManyToOne 关联OneToMany

  /** 注文区分 */

  @OneToMany(() => OrderInfo, (orderInfo) => orderInfo.aaa, {

    nullable: true,

    lazy: true,

  })

  orderInfo?: OrderInfo;