Membuat Model & Table

Buat file dengan nama product.js dalam folder models, dan isi dengan script seperti dibawah:

// folder-project/models/product.js

const Sequelize = require('sequelize'); 
const db = require('../config/db.js');

const product = db.define('product', {
  'id': {
    type: Sequelize.INTEGER,
    primaryKey: true,
    autoIncrement: true
  },
  'name': Sequelize.STRING,
  'price': Sequelize.INTEGER,
  'image': {
    type: Sequelize.STRING
  },
  'createdAt': {
    type: Sequelize.DATE,
    defaultValue: Sequelize.NOW
  },    
  'updatedAt': {
    type: Sequelize.DATE,
    defaultValue: Sequelize.NOW
  }
}, {
  //prevent sequelize transform table name into plural
  freezeTableName: true,
});


module.exports = product;