title: Node Js (Sequelize) - Unhandled rejection SequelizeDatabaseError: Unknown column 'id' in 'field list'
body: <p>I try to get two column values from my mysql database. </p>
  
  <p><strong>This is my model</strong></p>
  
  <pre><code>const Sequelize = require('sequelize');
  const db = require('../config/database');
  
  const AuthDetails = db.define('auth_details', {
      client_id : {
          type: Sequelize.STRING
      },
      client_secret : {
          type: Sequelize.STRING
      }
  },{
      timestamps : false
  });
  
  
  module.exports = AuthDetails;
  </code></pre>
  
  <p><strong>And, This is my route</strong></p>
  
  <pre><code>router.post('/login', (req, res, next) =&gt; {
  // console.log(req.body);
  
     Users.findOne( { where : { mobile_number: req.body.mobile_number}})
    .then(users =&gt; {
  
    UserAuthDet.findAll({   
      where: {
        client_id: req.body.client_id,
        client_secret: req.body.client_secret
      }
    });
  });
  </code></pre>
  
  <p>I'm having the error, while getting the client_id and client_secret from the database. </p>
  
  <p><strong>My error</strong></p>
  
  <p><a href="https://i.stack.imgur.com/cVlzd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/cVlzd.png" alt="enter image description here"></a></p>
  
  <p><strong>UPDATED :</strong> Database.js File</p>
  
  <pre><code>const Sequelize = require('sequelize');
  
  module.exports = new Sequelize('mydbname', 'root', '', {
    host: 'localhost',
    dialect: 'mysql',
    operatorsAliases: false,
  
    pool: {
      max: 5,
      min: 0,
      acquire: 30000,
      idle: 10000
    },
  
  });
  </code></pre>