module.exports = function(sequelize, DataTypes) {
var ReportMailHistory = sequelize.define('ReportMailHistory', {
+ sourceid: DataTypes.INTEGER,
uniqueid: DataTypes.STRING,
timeslot: DataTypes.INTEGER,
subject: DataTypes.STRING,
},
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,
- connectedAt: DataTypes.DATE
+ connectedAt: DataTypes.DATE,
+ rejectedAt: DataTypes.DATE,
+ from: DataTypes.STRING
}, {
- tableName: 'report_mail_history'
+ tableName: 'report_mail_history',
+ indexes: [{
+ name: 'sourceid',
+ fields: ['sourceid']
+ }]
});
-
+ ReportMailHistory.removeAttribute('id');
return ReportMailHistory;
};