5 module.exports = function(sequelize, DataTypes) {
7 var ReportQueueHistory = sequelize.define('ReportQueueHistory', {
8 sourceid: DataTypes.INTEGER,
9 uniqueid: DataTypes.STRING,
10 calleridnum: DataTypes.STRING,
11 calleridname: DataTypes.STRING,
12 queue: DataTypes.STRING,
13 queuecallerjoinAt: DataTypes.DATE,
14 queuecallerleaveAt: DataTypes.DATE,
15 position: DataTypes.INTEGER,
16 count: DataTypes.INTEGER,
18 type: DataTypes.BOOLEAN,
21 queuecallerabandonAt: DataTypes.DATE,
22 queuecallercomplete: {
23 type: DataTypes.BOOLEAN,
26 queuecallercompleteAt: DataTypes.DATE,
28 type: DataTypes.BOOLEAN,
31 queuecallerexitAt: DataTypes.DATE,
32 queuecallerexitreason: DataTypes.STRING,
33 originalposition: DataTypes.INTEGER,
34 channel: DataTypes.STRING,
35 channelstate: DataTypes.INTEGER,
36 channelstatedesc: DataTypes.STRING,
37 connectedlinenum: DataTypes.STRING,
38 connectedlinename: DataTypes.STRING,
39 language: DataTypes.STRING,
40 accountcode: DataTypes.STRING,
41 context: DataTypes.STRING,
42 exten: DataTypes.STRING,
43 priority: DataTypes.STRING,
44 holdtime: DataTypes.INTEGER,
46 type: DataTypes.BOOLEAN,
49 lastAssignedTo: DataTypes.STRING
51 tableName: 'report_queue_history',
60 ReportQueueHistory.removeAttribute('id');
61 return ReportQueueHistory;