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 contacts: DataTypes.STRING,
14 uniqueid: DataTypes.STRING,
15 calleridnum: DataTypes.STRING,
16 calleridname: DataTypes.STRING,
17 queue: DataTypes.STRING,
18 interface: DataTypes.STRING,
19 membername: DataTypes.STRING,
20 agentcalledAt: DataTypes.DATE,
21 agentconnectAt: DataTypes.DATE,
22 holdtime: DataTypes.INTEGER,
24 type: DataTypes.BOOLEAN,
27 agentcompleteAt: DataTypes.DATE,
28 talktime: DataTypes.INTEGER,
30 type: DataTypes.BOOLEAN,
33 acwtime: DataTypes.INTEGER,
34 reason: DataTypes.STRING,
36 type: DataTypes.BOOLEAN,
39 agentringnoanswerAt: DataTypes.DATE,
41 type: DataTypes.BOOLEAN,
44 agentdumpAt: DataTypes.DATE,
45 lastevent: DataTypes.STRING,
46 channel: DataTypes.STRING,
47 channelstate: DataTypes.INTEGER,
48 channelstatedesc: DataTypes.STRING,
49 connectedlinenum: DataTypes.STRING,
50 connectedlinename: DataTypes.STRING,
51 language: DataTypes.STRING,
52 accountcode: DataTypes.STRING,
53 context: DataTypes.STRING,
54 exten: DataTypes.STRING,
55 priority: DataTypes.STRING,
56 destchannel: DataTypes.STRING,
57 destchannelstate: DataTypes.INTEGER,
58 destchannelstatedesc: DataTypes.STRING,
59 destcalleridnum: DataTypes.STRING,
60 destcalleridname: DataTypes.STRING,
61 destconnectedlinenum: DataTypes.STRING,
62 destconnectedlinename: DataTypes.STRING,
63 destlanguage: DataTypes.STRING,
64 destaccountcode: DataTypes.STRING,
65 destcontext: DataTypes.STRING,
66 destexten: DataTypes.STRING,
67 destpriority: DataTypes.STRING,
68 destuniqueid: DataTypes.STRING,
69 messageId: DataTypes.STRING,
70 inReplyTo: DataTypes.STRING,
71 subject: DataTypes.STRING,
72 from: DataTypes.STRING,
75 attachment: DataTypes.TEXT,
79 type: DataTypes.ENUM('SENT', 'SENDING', 'RECEIVED', 'FAILED')
81 url: DataTypes.STRING,
82 app: DataTypes.STRING,
83 appdata: DataTypes.STRING
85 tableName: 'report_integration_history'
88 ReportIntegrationHistory.removeAttribute('id');
89 return ReportIntegrationHistory;