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 subtypeChannel: DataTypes.STRING,
11 exitStatus: DataTypes.STRING,
12 ticketId: DataTypes.STRING,
13 integrationId: DataTypes.INTEGER,
14 contacts: DataTypes.STRING,
15 uniqueid: DataTypes.STRING,
16 calleridnum: DataTypes.STRING,
17 calleridname: DataTypes.STRING,
18 queue: DataTypes.STRING,
19 interface: DataTypes.STRING,
20 membername: DataTypes.STRING,
21 agentcalledAt: DataTypes.DATE,
22 agentconnectAt: DataTypes.DATE,
23 holdtime: DataTypes.INTEGER,
25 type: DataTypes.BOOLEAN,
28 agentcompleteAt: DataTypes.DATE,
29 talktime: DataTypes.INTEGER,
31 type: DataTypes.BOOLEAN,
34 acwtime: DataTypes.INTEGER,
35 reason: DataTypes.STRING,
37 type: DataTypes.BOOLEAN,
40 agentringnoanswerAt: DataTypes.DATE,
42 type: DataTypes.BOOLEAN,
45 agentdumpAt: DataTypes.DATE,
46 lastevent: DataTypes.STRING,
47 channel: DataTypes.STRING,
48 channelstate: DataTypes.INTEGER,
49 channelstatedesc: DataTypes.STRING,
50 connectedlinenum: DataTypes.STRING,
51 connectedlinename: DataTypes.STRING,
52 language: DataTypes.STRING,
53 accountcode: DataTypes.STRING,
54 context: DataTypes.STRING,
55 exten: DataTypes.STRING,
56 priority: DataTypes.STRING,
57 destchannel: DataTypes.STRING,
58 destchannelstate: DataTypes.INTEGER,
59 destchannelstatedesc: DataTypes.STRING,
60 destcalleridnum: DataTypes.STRING,
61 destcalleridname: DataTypes.STRING,
62 destconnectedlinenum: DataTypes.STRING,
63 destconnectedlinename: DataTypes.STRING,
64 destlanguage: DataTypes.STRING,
65 destaccountcode: DataTypes.STRING,
66 destcontext: DataTypes.STRING,
67 destexten: DataTypes.STRING,
68 destpriority: DataTypes.STRING,
69 destuniqueid: DataTypes.STRING,
70 messageId: DataTypes.STRING,
71 inReplyTo: DataTypes.STRING,
72 subject: DataTypes.STRING,
73 from: DataTypes.STRING,
76 attachment: DataTypes.TEXT,
80 type: DataTypes.ENUM('SENT', 'SENDING', 'RECEIVED', 'FAILED')
82 url: DataTypes.STRING,
83 app: DataTypes.STRING,
84 appdata: DataTypes.STRING
86 tableName: 'report_integration_history'
89 ReportIntegrationHistory.removeAttribute('id');
90 return ReportIntegrationHistory;