Sequelize-typescript: how to use unique key instead of primary key in one-to-one assoction

[chaoxihailing]

I have two model AdminUser, Organization, and I want to use unique key Organzation.code assoction AdminUser.organizationCode instead of primary key id

export class AdminUser extends Model<AdminUser> {
    @PrimaryKey
    @AutoIncrement
    @Column
    public id: number;

   @ForeignKey(() => Organization)
    public organizationCode: string;

    @BelongsTo(() => Organization, "organizationCode")
    public organization: Organization;
}

export class Organization extends Model<Organization> {
    @PrimaryKey
    @AutoIncrement
    @Column
    public id: number;

    @Unique
    @Column
    public code: string;

    @HasOne(() => AdminUser)
    public adminUser: AdminUser;
}

but sql query is still use organization.id associate

how to make right associate like AdminUser`.`organizationCode` = `organization`.`code

[RobinBuschmann]

Hey @chaoxihailing, actually you need to use targetKey like so:

@BelongsTo(() => Organization, {targetKey: 'code'})

⚠️But this doesn't seem to work with HasOne. Regarding this it is an issue with sequelize.

So you could use @HasMany as a workaround :/

[chaoxihailing]

thanks，it can work normally