server/models/history/report_member_history.js

   1 /**
   2  * DIAL Model
   3  */
   4
   5 module.exports = function(sequelize, DataTypes) {
   6
   7   var ReportMemberHistory = sequelize.define('ReportMemberHistory', {
   8     sourceid: DataTypes.INTEGER,
   9     channel: DataTypes.STRING,
  10     membername: DataTypes.STRING,
  11     interface: DataTypes.STRING,
  12     type: {
  13       type: DataTypes.STRING,
  14       defaultValue: 'DEFAULT PAUSE'
  15     },
  16     duration: DataTypes.INTEGER,
  17     enterAt: DataTypes.DATE,
  18     exitAt: DataTypes.DATE,
  19     data1: DataTypes.STRING,
  20     data2: DataTypes.STRING,
  21     data3: DataTypes.STRING,
  22     data4: DataTypes.STRING,
  23     data5: DataTypes.STRING,
  24     role: DataTypes.STRING,
  25     internal: DataTypes.INTEGER(11),
  26     uniqueid: DataTypes.STRING
  27   }, {
  28     tableName: 'report_member_history',
  29     indexes: [{
  30         name: 'sourceid',
  31         fields: ['sourceid']
  32       }]
  33       // indexes: [{
  34       //   fields: ['membername', 'enterdate', 'exitdate']
  35       // }]
  36   });
  37
  38   ReportMemberHistory.removeAttribute('id');
  39   return ReportMemberHistory;
  40 };