module.exports = function(sequelize, DataTypes) {
var ReportChatHistory = sequelize.define('ReportChatHistory', {
-
+ sourceid: DataTypes.INTEGER,
uniqueid: DataTypes.STRING,
timeslot: DataTypes.INTEGER,
websitename: DataTypes.STRING,
websiteaddress: DataTypes.STRING,
websiteid: DataTypes.INTEGER,
application: DataTypes.STRING,
- agentid: DataTypes.INTEGER,
- agentname: DataTypes.STRING,
+ memberid: DataTypes.INTEGER,
+ membername: DataTypes.STRING,
visitorid: DataTypes.STRING,
visitorname: DataTypes.STRING,
visitoremail: DataTypes.STRING,
- queueid: DataTypes.INTEGER,
+ queue: DataTypes.INTEGER,
queuename: DataTypes.STRING,
roomid: DataTypes.INTEGER,
reason: {
},
connectid: {
type: DataTypes.STRING,
- unique: true,
- set: function(agentconnectedAt) {
- this.setDataValue('connectid', this.uniqueid);
- this.setDataValue('reason', 'connect');
- this.setDataValue('connectedAt', moment().format("YYYY-MM-DD HH:mm:ss"));
- }
+ unique: 'connectid'
},
calledAt: DataTypes.DATE,
+ rejectedAt: DataTypes.DATE,
connectedAt: DataTypes.DATE
}, {
- tableName: 'report_chat_history'
+ tableName: 'report_chat_history',
+ indexes: [{
+ name: 'sourceid',
+ fields: ['sourceid']
+ }]
});
+ ReportChatHistory.removeAttribute('id');
+
return ReportChatHistory;
};