creating special primary key in sequelize

Asked Nov 10 '22 at 06:45

Active Nov 10 '22 at 09:00

Viewed 25 times

I am building my DB model using sequelize, and my tables are the following:

My issue is that, how could I make the primary key (id) of the packageTypes record as follows: productId + id , so if the productId is 1 and the packageType id is 3 so the id will be 13

edited Nov 10 '22 at 09:00

Shadow

33,525
10
51
64

asked Nov 10 '22 at 06:45

Firas SCMP

2

In short, don't. Create a composite primary key containing both `(productId, packageTypeID)`. Less duplication, same uniqueness effect. – danblack Nov 10 '22 at 06:57
thank you, so I'll keep the primary key as default – Firas SCMP Nov 10 '22 at 06:58
Be aware that Sequelize doesn't support composite PKs. – Anatoly Nov 10 '22 at 17:00
1

So [this answer](https://stackoverflow.com/questions/59163675/composite-primary-key-in-sequelize) isn't right? – danblack Nov 11 '22 at 03:06

creating special primary key in sequelize

0 Answers0