5 module.exports = function(sequelize, DataTypes) {
6 var ReportAgentHistory = sequelize.define('ReportAgentHistory', {
7 uniqueid: DataTypes.STRING,
8 calleridnum: DataTypes.STRING,
9 calleridname: DataTypes.STRING,
10 queue: DataTypes.STRING,
11 interface: DataTypes.STRING,
12 membername: DataTypes.STRING,
13 agentcalledAt: DataTypes.DATE,
14 agentconnectAt: DataTypes.DATE,
15 holdtime: DataTypes.INTEGER,
17 type: DataTypes.BOOLEAN,
20 agentcompleteAt: DataTypes.DATE,
21 talktime: DataTypes.INTEGER,
23 type: DataTypes.BOOLEAN,
26 acwtime: DataTypes.INTEGER,
27 reason: DataTypes.STRING,
29 type: DataTypes.BOOLEAN,
32 agentringnoanswerAt: DataTypes.DATE,
34 type: DataTypes.BOOLEAN,
37 agentdumpAt: DataTypes.DATE,
38 channel: DataTypes.STRING,
39 channelstate: DataTypes.INTEGER,
40 channelstatedesc: DataTypes.STRING,
41 connectedlinenum: DataTypes.STRING,
42 connectedlinename: DataTypes.STRING,
43 language: DataTypes.STRING,
44 accountcode: DataTypes.STRING,
45 context: DataTypes.STRING,
46 exten: DataTypes.STRING,
47 priority: DataTypes.STRING,
48 destchannel: DataTypes.STRING,
49 destchannelstate: DataTypes.INTEGER,
50 destchannelstatedesc: DataTypes.STRING,
51 destcalleridnum: DataTypes.STRING,
52 destcalleridname: DataTypes.STRING,
53 destconnectedlinenum: DataTypes.STRING,
54 destconnectedlinename: DataTypes.STRING,
55 destlanguage: DataTypes.STRING,
56 destaccountcode: DataTypes.STRING,
57 destcontext: DataTypes.STRING,
58 destexten: DataTypes.STRING,
59 destpriority: DataTypes.STRING,
60 destuniqueid: DataTypes.STRING
62 tableName: 'report_agent_history'
65 ReportAgentHistory.removeAttribute('id');
66 return ReportAgentHistory;