order_associate.js

var Order = sequelize.define('Order',{
        sale_net_price: Sequelize.DECIMAL(10, 2),
},{
        underscored: true,
        freezeTableName: true,
        tableName: 'orders'
});

var Transaction = sequelize.define('Transaction',{
     order_id: Sequelize.INTEGER,
     transaction_mode: {type: Sequelize.ENUM, values: ['STRIPE','PAYPAL']}
},{
        underscored: true,
        freezeTableName: true,
        tableName: 'transactions'
});
Order.hasOne(Transaction,{foreignKey:'order_id'});

Order.findAll({include:[Transaction]},{where:{}});