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