5 var moment = require('moment');
7 module.exports = function(sequelize, DataTypes) {
9 var ReportSmsHistory = sequelize.define('ReportSmsHistory', {
10 uniqueid: DataTypes.STRING,
11 timeslot: DataTypes.INTEGER,
12 accountid: DataTypes.STRING,
13 accountname: DataTypes.STRING,
14 accountnumber: DataTypes.STRING,
15 application: DataTypes.STRING,
16 memberid: DataTypes.INTEGER,
17 membername: DataTypes.STRING,
18 queue: DataTypes.INTEGER,
19 queuename: DataTypes.STRING,
20 roomid: DataTypes.INTEGER,
21 messageid: DataTypes.INTEGER,
23 type: DataTypes.STRING,
24 defaultValue: 'called'
27 type: DataTypes.STRING,
30 this.setDataValue('connectid', this.uniqueid);
31 this.setDataValue('reason', 'connect');
32 this.setDataValue('connectedAt', moment().format("YYYY-MM-DD HH:mm:ss"));
35 calledAt: DataTypes.DATE,
36 rejectedAt: DataTypes.DATE,
37 connectedAt: DataTypes.DATE
39 tableName: 'report_sms_history'
42 return ReportSmsHistory;