How to join tables in sequelize
I have a question on sequelize (cli). I have two tables. now I have an n:m relation. So I will need a join table. Something like this
zoneId | chargeId
-------+---------
1 3
4 5
I'm not sure how to do this in sequelize. Do I really need a new model for this? Is there any other best practice for this?
sequelize.js jointable
edited Nov 25 '18 at 12:37
marc_s
581k13011201267
asked Nov 25 '18 at 10:28
b0ssb0ss
395
add a comment |
I have a question on sequelize (cli). I have two tables. now I have an n:m relation. So I will need a join table. Something like this
zoneId | chargeId
-------+---------
1 3
4 5
I'm not sure how to do this in sequelize. Do I really need a new model for this? Is there any other best practice for this?
sequelize.js jointable
edited Nov 25 '18 at 12:37
marc_s
581k13011201267
asked Nov 25 '18 at 10:28
b0ssb0ss
395
add a comment |
I have a question on sequelize (cli). I have two tables. now I have an n:m relation. So I will need a join table. Something like this
zoneId | chargeId
-------+---------
1 3
4 5
I'm not sure how to do this in sequelize. Do I really need a new model for this? Is there any other best practice for this?
sequelize.js jointable
edited Nov 25 '18 at 12:37
marc_s
581k13011201267
asked Nov 25 '18 at 10:28
b0ssb0ss
395
I have a question on sequelize (cli). I have two tables. now I have an n:m relation. So I will need a join table. Something like this
zoneId | chargeId
-------+---------
1 3
4 5
I'm not sure how to do this in sequelize. Do I really need a new model for this? Is there any other best practice for this?
sequelize.js jointable
sequelize.js jointable
edited Nov 25 '18 at 12:37
marc_s
581k13011201267
asked Nov 25 '18 at 10:28
b0ssb0ss
395
edited Nov 25 '18 at 12:37
marc_s
581k13011201267
asked Nov 25 '18 at 10:28
b0ssb0ss
395
edited Nov 25 '18 at 12:37
marc_s
581k13011201267
edited Nov 25 '18 at 12:37
marc_s
581k13011201267
edited Nov 25 '18 at 12:37
marc_s
581k13011201267
581k13011201267
asked Nov 25 '18 at 10:28
b0ssb0ss
395
asked Nov 25 '18 at 10:28
b0ssb0ss
395
asked Nov 25 '18 at 10:28
b0ssb0ss
395
395
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
For storing Many to many relationships you always need a join table. You have to create a new model which will store all these mappings. Its independent of ORM you use. Many to many relationships can't be stored without a join table.
Refer this blog for many to many relationships in Sequelize with Postgres
https://medium.com/@THEozmic/how-to-create-many-to-many-relationship-using-sequelize-orm-postgres-on-express-677753a3edb5
answered Nov 25 '18 at 11:00
Rahul SharmaRahul Sharma
838717
welcome buddy :)
– Rahul Sharma
Nov 25 '18 at 13:35
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53466592%2fhow-to-join-tables-in-sequelize%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
For storing Many to many relationships you always need a join table. You have to create a new model which will store all these mappings. Its independent of ORM you use. Many to many relationships can't be stored without a join table.
Refer this blog for many to many relationships in Sequelize with Postgres
https://medium.com/@THEozmic/how-to-create-many-to-many-relationship-using-sequelize-orm-postgres-on-express-677753a3edb5
answered Nov 25 '18 at 11:00
Rahul SharmaRahul Sharma
838717
welcome buddy :)
– Rahul Sharma
Nov 25 '18 at 13:35
add a comment |
For storing Many to many relationships you always need a join table. You have to create a new model which will store all these mappings. Its independent of ORM you use. Many to many relationships can't be stored without a join table.
Refer this blog for many to many relationships in Sequelize with Postgres
https://medium.com/@THEozmic/how-to-create-many-to-many-relationship-using-sequelize-orm-postgres-on-express-677753a3edb5
answered Nov 25 '18 at 11:00
Rahul SharmaRahul Sharma
838717
welcome buddy :)
– Rahul Sharma
Nov 25 '18 at 13:35
add a comment |
For storing Many to many relationships you always need a join table. You have to create a new model which will store all these mappings. Its independent of ORM you use. Many to many relationships can't be stored without a join table.
Refer this blog for many to many relationships in Sequelize with Postgres
https://medium.com/@THEozmic/how-to-create-many-to-many-relationship-using-sequelize-orm-postgres-on-express-677753a3edb5
answered Nov 25 '18 at 11:00
Rahul SharmaRahul Sharma
838717
For storing Many to many relationships you always need a join table. You have to create a new model which will store all these mappings. Its independent of ORM you use. Many to many relationships can't be stored without a join table.
Refer this blog for many to many relationships in Sequelize with Postgres
https://medium.com/@THEozmic/how-to-create-many-to-many-relationship-using-sequelize-orm-postgres-on-express-677753a3edb5
answered Nov 25 '18 at 11:00
Rahul SharmaRahul Sharma
838717
answered Nov 25 '18 at 11:00
Rahul SharmaRahul Sharma
838717
answered Nov 25 '18 at 11:00
Rahul SharmaRahul Sharma
838717
answered Nov 25 '18 at 11:00
Rahul SharmaRahul Sharma
838717
838717
welcome buddy :)
– Rahul Sharma
Nov 25 '18 at 13:35
add a comment |
welcome buddy :)
– Rahul Sharma
Nov 25 '18 at 13:35
welcome buddy :)
– Rahul Sharma
Nov 25 '18 at 13:35
welcome buddy :)
– Rahul Sharma
Nov 25 '18 at 13:35
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53466592%2fhow-to-join-tables-in-sequelize%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
