Notes for ORM Sequelize - required field while joining tables

sequelizeRequiredNote.js

// required: true - Sequelize Code
test = (guideId) => this.Manual.findAll({
  include: [
    {model: this.Topic, required: true, include: [
      {model: this.Guide, where: {id: guideId}}
    ]}
  ]
});
// required: true - Interpreted SQL (Modified for being readable)
SELECT "manual".*, "topics".*, "topics->guides".*
FROM "test"."manuals" AS "manual" 
INNER JOIN "test"."topics" AS "topics" ON "manual"."id" = "topics"."manual_id" 
INNER JOIN "test"."guides" AS "topics->guides" ON "topics"."id" = "topics->guides"."topic_id" AND "topics->guides"."id" = '37abff8e-003f-431a-8712-fe61c03f31f3';

// Without required - Sequelize Code
test = (guideId) => this.Manual.findAll({
  include: [
    {model: this.Topic, include: [
      {model: this.Guide, where: {id: guideId}}
    ]}
  ]
});
// Without required - Interpreted SQL (Modified for being readable)
SELECT "manual".*, "topics".*, "topics->guides".*
FROM "test"."manuals" AS "manual" 
LEFT OUTER JOIN "test"."topics" AS "topics" ON "manual"."id" = "topics"."manual_id" 
INNER JOIN "test"."guides" AS "topics->guides" ON "topics"."id" = "topics->guides"."topic_id" AND "topics->guides"."id" = '37abff8e-003f-431a-8712-fe61c03f31f3';

// required: false - Sequelize Code
test = (guideId) => this.Manual.findAll({
  include: [
    {model: this.Topic, include: [
      {model: this.Guide, required: false, where: {id: guideId}}
    ]}
  ]
});
// required: false - Interpreted SQL (Modified for being readable)
SELECT "manual".*, "topics".*, "topics->guides".*
FROM "test"."manuals" AS "manual" 
LEFT OUTER JOIN "test"."topics" AS "topics" ON "manual"."id" = "topics"."manual_id" 
LEFT OUTER JOIN "test"."guides" AS "topics->guides" ON "topics"."id" = "topics->guides"."topic_id" AND "topics->guides"."id" = '37abff8e-003f-431a-8712-fe61c03f31f3';