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