migrations-001.js

// external dependencies
const bPromise = require('bluebird');

// logic
exports.up = function(db, types) {
  return db.sequelize.transaction(bPromise.coroutine(function* (t) {

    yield db.createTable('listings', {

      id: {
        type: types.INTEGER,
        allowNull: false,
        autoIncrement: true
      }

    }, {transaction: t});

    yield db.createTable('shipments', {
      id: {
        type: types.INTEGER,
        allowNull: false,
        autoIncrement: true
      }
    }, {transaction: t});

  }));
};

exports.down = function(db, types) {
  return db.sequelize.transaction(bPromise.coroutine(function* (t) {

    yield db.dropTable('listings', {transaction: t});
    yield db.dropTable('shipments', {transaction: t});

  }));
};

models-listing.js

// exports
module.exports = function(db, types) {

  const properties = {

    id: {
      type: types.INTEGER,
      allowNull: false,
      autoIncrement: true
    },
    title: types.STRING,
    description: types.TEXT,
    namedPriceAmount: types.FLOAT,
    namedPriceCurrency: types.STRING,
    createdAt: types.DATE,
    createdBy: types.INTEGER.UNSIGNED,
    public: types.BOOLEAN,
    expirationDate: types.DATE,
    active: types.BOOLEAN,
    brokered: types.BOOLEAN,
    code: types.INTEGER.UNSIGNED,
    referenceId: types.STRING,
    meta: types.JSONB

  };

  const methods = {

    associate: function(models) {
      models.Listing.hasMany(models.Shipment, {
        as: 'shipments',
        foreignKey: 'parentId'
      });
    }

  };

  return db.define('listings', properties, methods);

};