sequelize-cross-db-model.js

// models/user.js

module.exports = (sequelize, DataTypes) =>
  sequelize.define(
    "user",
    {
      id: {
        type: DataTypes.INTEGER(11),
        allowNull: false,
        primaryKey: true,
        autoIncrement: true
      },
      name: {
        type: DataTypes.STRING(255),
        allowNull: true
      }
    },
    {
      tableName: "user",
      timestamps: false
    }
  );

// models/order.js

module.exports = (sequelize, DataTypes) =>
  sequelize.define(
    "order",
    {
      id: {
        type: DataTypes.INTEGER(11),
        allowNull: false,
        primaryKey: true,
        autoIncrement: true
      },
      user_id: {
        type: DataTypes.INTEGER(11),
        allowNull: false
      },
      order_date: {
        type: DataTypes.DATE,
        allowNull: true
      }
    },
    {
      tableName: "order",
      timestamps: false
    }
  );

// models/product.js


module.exports = (sequelize, DataTypes) =>
  sequelize.define(
    "product",
    {
      id: {
        type: DataTypes.INTEGER(11),
        allowNull: false,
        primaryKey: true,
        autoIncrement: true
      },
      order_id: {
        type: DataTypes.INTEGER(11),
        allowNull: false
      },
      name: {
        type: DataTypes.STRING(255),
        allowNull: true
      }
    },
    {
      tableName: "product",
      timestamps: false
    }
  );