mysql - Sequilize association for 2 foriegn key of same model -


i need execute below query using sequelize

select  *      haulerrfquotes     left join  quotes       on   quotes.jobid = haulerrfquotes.jobid       ,  haulerrfquotes.haulerid = quotes.haulerid      haulerrfquotes.jobid = '11'  

but not getting how use 2 foriegn keys in same model(haulerrfquotes) , create association of both foriegn keys single model (quotes) in node.js orm sequelize.js

haulerrfquotes needs index(jobid).

quotes needs index(haulerid, jobid) (or in opposite order).

are node.js and/or sequelize.js not providing that? if not, abandon them.


Comments