2 * report_integrations Model
5 module.exports = function(sequelize, DataTypes) {
7 var ReportIntegrationHistory = sequelize.define('ReportIntegrationHistory', {
8 integration: DataTypes.STRING,
9 eventChannel: DataTypes.STRING,
10 exitStatus: DataTypes.STRING,
11 ticketId: DataTypes.STRING,
12 integrationId: DataTypes.INTEGER,
13 uniqueid: DataTypes.STRING,
14 calleridnum: DataTypes.STRING,
15 calleridname: DataTypes.STRING,
16 queue: DataTypes.STRING,
17 interface: DataTypes.STRING,
18 membername: DataTypes.STRING,
19 agentcalledAt: DataTypes.DATE,
20 agentconnectAt: DataTypes.DATE,
21 holdtime: DataTypes.INTEGER,
23 type: DataTypes.BOOLEAN,
26 agentcompleteAt: DataTypes.DATE,
27 talktime: DataTypes.INTEGER,
29 type: DataTypes.BOOLEAN,
32 acwtime: DataTypes.INTEGER,
33 reason: DataTypes.STRING,
35 type: DataTypes.BOOLEAN,
38 agentringnoanswerAt: DataTypes.DATE,
40 type: DataTypes.BOOLEAN,
43 agentdumpAt: DataTypes.DATE,
44 lastevent: DataTypes.STRING,
45 channel: DataTypes.STRING,
46 channelstate: DataTypes.INTEGER,
47 channelstatedesc: DataTypes.STRING,
48 connectedlinenum: DataTypes.STRING,
49 connectedlinename: DataTypes.STRING,
50 language: DataTypes.STRING,
51 accountcode: DataTypes.STRING,
52 context: DataTypes.STRING,
53 exten: DataTypes.STRING,
54 priority: DataTypes.STRING,
55 destchannel: DataTypes.STRING,
56 destchannelstate: DataTypes.INTEGER,
57 destchannelstatedesc: DataTypes.STRING,
58 destcalleridnum: DataTypes.STRING,
59 destcalleridname: DataTypes.STRING,
60 destconnectedlinenum: DataTypes.STRING,
61 destconnectedlinename: DataTypes.STRING,
62 destlanguage: DataTypes.STRING,
63 destaccountcode: DataTypes.STRING,
64 destcontext: DataTypes.STRING,
65 destexten: DataTypes.STRING,
66 destpriority: DataTypes.STRING,
67 destuniqueid: DataTypes.STRING,
68 messageId: DataTypes.STRING,
69 inReplyTo: DataTypes.STRING,
70 subject: DataTypes.STRING,
71 from: DataTypes.STRING,
74 attachment: DataTypes.TEXT,
78 type: DataTypes.ENUM('SENT', 'SENDING', 'RECEIVED', 'FAILED')
81 tableName: 'report_integration_history'
84 ReportIntegrationHistory.removeAttribute('id');
85 return ReportIntegrationHistory;