title: "ER_BAD_FIELD_ERROR: Unknown column 'id' in 'field list'" sequelize with nodejs
body: <p>when i try to get data from a certain route in NODEJS thru Sequelize i get the error of unknown column which is neither in model nor route below is my code.</p>
  
  <p>my model </p>
  
  <pre><code>      module.exports = function(sequelize, DataTypes) {
      return sequelize.define('ProspectType', {
        ProspectTypeID: {
          type: DataTypes.INTEGER(11),
          allowNull: false
        },
        ProspectTypeName: {
          type: DataTypes.STRING(50),
          allowNull: true
        }
      }, {
        tableName: 'ProspectType'
      });
    };
  </code></pre>
  
  <p>my route</p>
  
  <pre><code>        .get('/prospectType', function (req, res) {
          models
              .ProspectType
              .findAll()
              .then(function (data) {
                  res
                      .json(data);
              })
              .catch(function (error) {
                  res
                      .boom
                      .notAcceptable(error);
              });
      })
  </code></pre>
  
  <p>even though there is no column 'id' i get this error</p>
  
  <pre><code>SequelizeDatabaseError: ER_BAD_FIELD_ERROR: Unknown column 'id' in 'field 
   list'
  </code></pre>