续集打字稿多对多关系模型数据

我正在使用sequelize续集打字稿 https://github.com/RobinBuschmann/sequelize-typescript图书馆，并试图实现以下关系：

Team.ts

@Scopes({
  withPlayers: {
    include: [{model: () => User}]
  }
})
@Table
export default class Team extends Model<Team> {

  @AllowNull(false)
  @Column
  name: string;

  @BelongsToMany(() => User, () => TeamPlayer)
  players: User[];
}

User.ts

@Scopes({
  withTeams: {
    include: [{model: () => Team, include: [ () => User ]}]
  }
})
@Table
export default class User extends Model<User> {

  @AllowNull(false)
  @Column
  firstName: string;

  @AllowNull(false)
  @Column
  lastName: string;

  @BelongsToMany(() => Team, () => TeamPlayer)
  teams: Team[];
}

TeamPlayer.ts

@DefaultScope({
  include: [() => Team, () => User],
  attributes: ['number']
})
@Table
export default class TeamPlayer extends Model<TeamPlayer> {

  @ForeignKey(() => User)
  @Column
  userId: number;

  @ForeignKey(() => Team)
  @Column
  teamId: number;

  @Unique
  @Column
  number: number;
}

现在，当查询玩家时，您将获得具有以下数据的对象：

{
  "id": 1,
  "name": "Doe's Team",
  "players": [
    {
      "id": 1,
      "firstName": "John",
      "lastName": "Doe",
      "TeamPlayer": {
        "userId": 1,
        "teamId": 1,
        "number": 32
    }
 }]
}

现在有几件事我无法完成。

1）我想重命名TeamPlayer诸如“会员资格”之类的东西；但不是通过更改类的名称 2）内容TeamPlayer不应该有id，但我希望它包含团队的数据，例如：

{
  "firstName": "John",
  "lastName": "Doe"
  "membership": {
     "number": 32
 }

在上面的课程中，我尝试将范围设置为TeamPlayer类只包含number在 - 的里面TeamMember包含，但没有效果。

我曾经有过TeamPlayer班级有直接会员资格team and player，但是该解决方案增加了冗余id到TeamPlayer类，并且也没有阻止团队中重复的成员资格。我确实可以手动（=在代码中）防止这些情况下的重复，但这感觉不太优雅。

我最终通过添加一对多关系来解决这个问题TeamPlayer to User and Team，并且还想出了制作方法teamId + userId通过添加另外两个字段来配对唯一@ForeignKey像这样：

TeamPlayer.ts

@Table
export default class TeamPlayer extends Model<TeamPlayer> {

  @BelongsTo(() => Team)
  team: Team;

  @ForeignKey(() => Team)
  @PrimaryKey
  @Column
  teamId: number;

  @BelongsTo(() => User)
  user: User;

  @ForeignKey(() => User)
  @PrimaryKey
  @Column
  userId: number;

  @Column
  number: number;
}

User.ts

@Table
export default class User extends Model<User> {

  @AllowNull(false)
  @Column
  firstName: string;

  @AllowNull(false)
  @Column
  lastName: string;

  @HasMany(() => TeamPlayer)
  teams: TeamPlayer[];
}

Team.ts

export default class Team extends Model<Team> {
  @AllowNull(false)
  @Column
  name: string;

  @HasMany(() => TeamPlayer)
  players: TeamPlayer[];
}

该解决方案允许我通过范围控制包含的查询属性，并为我提供正确的对象输出。