server/models/history/report_dial_history.js

   1 /**
   2  * DIAL Model
   3  */
   4
   5 module.exports = function(sequelize, DataTypes) {
   6
   7   var ReportDialHistory = sequelize.define('ReportDialHistory', {
   8     sourceid: DataTypes.INTEGER,
   9     privilege: DataTypes.STRING,
  10     channel: DataTypes.STRING,
  11     channelstate: DataTypes.INTEGER,
  12     channelstatedesc: DataTypes.STRING,
  13     calleridnum: DataTypes.STRING,
  14     calleridname: DataTypes.STRING,
  15     connectedlinenum: DataTypes.STRING,
  16     connectedlinename: DataTypes.STRING,
  17     language: DataTypes.STRING,
  18     accountcode: DataTypes.STRING,
  19     context: DataTypes.STRING,
  20     exten: DataTypes.STRING,
  21     priority: DataTypes.INTEGER,
  22     uniqueid: DataTypes.STRING,
  23     linkedid: DataTypes.STRING,
  24     destchannel: DataTypes.STRING,
  25     destchannelstate: DataTypes.INTEGER,
  26     destchannelstatedesc: DataTypes.STRING,
  27     destcalleridnum: DataTypes.STRING,
  28     destcalleridname: DataTypes.STRING,
  29     destconnectedlinenum: DataTypes.STRING,
  30     destconnectedlinename: DataTypes.STRING,
  31     destlanguage: DataTypes.STRING,
  32     destaccountcode: DataTypes.STRING,
  33     destcontext: DataTypes.STRING,
  34     destexten: DataTypes.STRING,
  35     destpriority: DataTypes.INTEGER,
  36     destuniqueid: DataTypes.STRING,
  37     destlinkedid: DataTypes.STRING,
  38     dialstring: DataTypes.STRING,
  39     dialstatus: DataTypes.STRING,
  40     starttime: DataTypes.DATE,
  41     answertime: DataTypes.DATE,
  42     endtime: DataTypes.DATE,
  43     lastevent: DataTypes.STRING,
  44     routeId: DataTypes.INTEGER
  45   }, {
  46     tableName: 'report_dial_history',
  47     indexes: [{
  48       name: 'sourceid',
  49       fields: ['sourceid']
  50     }]
  51   });
  52
  53   ReportDialHistory.removeAttribute('id');
  54   return ReportDialHistory;
  55 };