2 * report_integrations Model
5 module.exports = function(sequelize, DataTypes) {
7 var ReportIntegration = sequelize.define('ReportIntegration', {
8 integration: DataTypes.STRING,
9 event: DataTypes.STRING,
10 contacts: DataTypes.STRING,
11 uniqueid: DataTypes.STRING,
12 calleridnum: DataTypes.STRING,
13 calleridname: DataTypes.STRING,
14 queue: DataTypes.STRING,
15 interface: DataTypes.STRING,
16 membername: DataTypes.STRING,
17 agentcalledAt: DataTypes.DATE,
18 agentconnectAt: DataTypes.DATE,
19 holdtime: DataTypes.INTEGER,
21 type: DataTypes.BOOLEAN,
24 agentcompleteAt: DataTypes.DATE,
25 talktime: DataTypes.INTEGER,
27 type: DataTypes.BOOLEAN,
30 acwtime: DataTypes.INTEGER,
31 reason: DataTypes.STRING,
33 type: DataTypes.BOOLEAN,
36 agentringnoanswerAt: DataTypes.DATE,
38 type: DataTypes.BOOLEAN,
41 agentdumpAt: DataTypes.DATE,
42 lastevent: DataTypes.STRING,
43 channel: DataTypes.STRING,
44 channelstate: DataTypes.INTEGER,
45 channelstatedesc: DataTypes.STRING,
46 connectedlinenum: DataTypes.STRING,
47 connectedlinename: DataTypes.STRING,
48 language: DataTypes.STRING,
49 accountcode: DataTypes.STRING,
50 context: DataTypes.STRING,
51 exten: DataTypes.STRING,
52 priority: DataTypes.STRING,
53 destchannel: DataTypes.STRING,
54 destchannelstate: DataTypes.INTEGER,
55 destchannelstatedesc: DataTypes.STRING,
56 destcalleridnum: DataTypes.STRING,
57 destcalleridname: DataTypes.STRING,
58 destconnectedlinenum: DataTypes.STRING,
59 destconnectedlinename: DataTypes.STRING,
60 destlanguage: DataTypes.STRING,
61 destaccountcode: DataTypes.STRING,
62 destcontext: DataTypes.STRING,
63 destexten: DataTypes.STRING,
64 destpriority: DataTypes.STRING,
65 destuniqueid: DataTypes.STRING,
66 messageId: DataTypes.STRING,
67 inReplyTo: DataTypes.STRING,
68 subject: DataTypes.STRING,
69 from: DataTypes.STRING,
72 attachment: DataTypes.TEXT,
76 type: DataTypes.ENUM('SENT', 'SENDING', 'RECEIVED', 'FAILED')
79 tableName: 'report_integration'
82 return ReportIntegration;