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     channel: DataTypes.STRING,
   9     membername: DataTypes.STRING,
  10     interface: DataTypes.STRING,
  11     type: {
  12       type: DataTypes.STRING,
  13       defaultValue: 'DEFAULT PAUSE'
  14     },
  15     duration: DataTypes.INTEGER,
  16     enterAt: DataTypes.DATE,
  17     exitAt: DataTypes.DATE,
  18     data1: DataTypes.STRING,
  19     data2: DataTypes.STRING,
  20     data3: DataTypes.STRING,
  21     data4: DataTypes.STRING,
  22     data5: DataTypes.STRING
  23   }, {
  24     tableName: 'report_member_history',
  25     // indexes: [{
  26     //   fields: ['membername', 'enterdate', 'exitdate']
  27     // }]
  28   });
  29
  30   ReportMemberHistory.removeAttribute('id');
  31   return ReportMemberHistory;
  32 };