5 var moment = require('moment');
7 module.exports = function(sequelize, DataTypes) {
9 var ReportSms = sequelize.define('ReportSms', {
10 uniqueid: DataTypes.STRING,
11 timeslot: DataTypes.INTEGER,
12 from: DataTypes.STRING,
13 accountid: DataTypes.STRING,
14 accountname: DataTypes.STRING,
15 accountnumber: DataTypes.STRING,
16 application: DataTypes.STRING,
17 memberid: DataTypes.INTEGER,
18 membername: DataTypes.STRING,
19 queue: DataTypes.INTEGER,
20 queuename: DataTypes.STRING,
21 roomid: DataTypes.INTEGER,
22 messageid: DataTypes.INTEGER,
24 type: DataTypes.STRING,
25 defaultValue: 'called'
28 type: DataTypes.STRING,
30 set: function(connectid) {
31 this.setDataValue('connectid', connectid);
32 this.setDataValue('reason', 'connect');
33 this.setDataValue('connectedAt', moment().format("YYYY-MM-DD HH:mm:ss"));
36 calledAt: DataTypes.DATE,
39 set: function(rejectedAt) {
40 this.setDataValue('rejectedAt', rejectedAt);
41 this.setDataValue('reason', 'rejected');
44 connectedAt: DataTypes.DATE
46 tableName: 'report_sms'