Updated Review & Endorsement

rev_endorse.js

const Review = sequelize.define('Review', {
  userId:  DataTypes.UUID,
  providerNPI: DataTypes.BIGINT,
  ratingFields: DataTypes.JSON,
  rating: DataTypes.INTEGER,
  isReported: DataTypes.INTEGER,
  message: DataTypes.TEXT
}, {
  tableName: 'reviews'
})

const Endorsement = sequelize.define('Endorsement', {
  endorserNPI:  DataTypes.BIGINT,
  endorseeNPI: DataTypes.BIGINT,
  areas: {
    type: DataTypes.STRING,
    get() {
      const areasString = this.getDataValue('areas');
      return areasString ? areasString.split(';') : [];
    },
    set(val) {
      this.setDataValue('areas', val.join(';'));
    },
  },
  isEndorsement: DataTypes.BOOLEAN,
  message: {
    type: DataTypes.TEXT,
    defaultValue: ''
  },
  isReported: DataTypes.INTEGER,
  anonymous: DataTypes.BOOLEAN,
  userId: DataTypes.UUID
}, {
  tableName: 'endorsements'
})