composite key and foreign keys

[ShintaroNippon]

HI there i'm trying to use sequelize typescript in order to create a composite unique key

this is my code:

@Column({
		field: 'is_default',
		type: DataType.BOOLEAN,
		unique: 'active_unique',
	})
	public isDefault: boolean;
	// ForeignKeys
	@ForeignKey(() => Profile)
	@Column({
		allowNull: false,
		field: 'profile_id',
		type: DataType.STRING(255),
		unique: 'active_unique',
	})

But I'm having problems in creation new rows with different Profile and online unique in isDefault...

Does any can help please?

Thanks in advance
Carlos Vieira

[blankstar85]

Can you post more of your code? looks like your missing your second column value, i'm guessing should be profileID?
What is the error, are you getting a foreign key constraint? Are you getting a index error ( unique, already exists).
How are you setting up the database?

[RobinBuschmann]

Hey @ShintaroNippon, as @blankstar85 stated, we need some more information (error message, best would be an example repo, which reproduces the issue) in order to help.

[ShintaroNippon]

Hi, thanks by the reply..
Yes, its profileID...
And yes its
"What is the error, are you getting a foreign key constraint? Are you getting an index error ( unique, already exists)."

That's what is happening.
THanks

[ShintaroNippon]

// PrimaryKey
@PrimaryKey
@ForeignKey(() => Address)
@Column({
	allowNull: false,
	field: 'address_id',
	type: DataType.INTEGER,
})
public addressId: number;

// Fields
@Column({
	field: 'vat_number',
})
public vatNumber: string;

@Column({
	field: 'is_default',
	type: DataType.BOOLEAN,
	unique: 'active_unique',
})
public isDefault: boolean;

// ForeignKeys
@ForeignKey(() => Profile)
@Column({
	allowNull: false,
	field: 'profile_id',
	unique: 'active_unique',
})
public profileId: string;

// Belongs
@BelongsTo(() => Address)
public address: Address;

Additional information:

• The logging is showing the constraint UNIQUE active_unique (is_default), but this should be UNIQUE active_unique (is_default, profile_id).

• In the logging also is showing the constraint UNIQUE AddressId_profileId_unique (address_id, profile_id), but I don't know why it is happening.

[RobinBuschmann]

@ShintaroNippon For foreign keys you have to define it within the association options like so:

@BelongsTo(() => Profile, {
    foreignKey: {
      unique: 'active_unique'
    }
  })

Hope this helps!

[RobinBuschmann]

@ShintaroNippon Does this help? Can we close this issue now?

[ShintaroNippon]

HI, sorry,
yes indeed... its working.
Many thanks
Carlos Vieira