module.exports = function(sequelize, DataTypes) {
- var ReportMailSessionHistory = sequelize.define('ReportMailSessionHistory', {
+ var ReportMailSession = sequelize.define('ReportMailSessionHistory', {
uniqueid: {
- type: DataTypes.INTEGER
+ type: DataTypes.STRING,
+ unique: true
},
subject: DataTypes.STRING,
- from: DataTypes.STRING,
- cc: DataTypes.STRING,
- attachment: DataTypes.BOOLEAN,
+ accountid: DataTypes.STRING,
accountname: DataTypes.STRING,
accountaddress: DataTypes.STRING,
- fullname: DataTypes.STRING,
+ application: DataTypes.STRING,
+ memberid: DataTypes.STRING,
membername: DataTypes.STRING,
- mailqueuename: DataTypes.STRING,
- mailjoinAt: DataTypes.DATE,
- mailleaveAt: DataTypes.DATE,
- mailunmanagedAt: DataTypes.DATE,
+ queue: DataTypes.INTEGER,
+ queuename: DataTypes.STRING,
+ roomid: DataTypes.INTEGER,
+ fidelity: {
+ type: DataTypes.INTEGER,
+ defaultValue: 0
+ },
+ holdtime: DataTypes.INTEGER,
+ queuecallerjoinAt: DataTypes.DATE,
+ queuecallerleaveAt: DataTypes.DATE,
+ queuecallerunmanagedAt: DataTypes.DATE,
+ queuecallerabandonedAt: DataTypes.DATE
}, {
tableName: 'report_mail_session_history'
});
- ReportMailSessionHistory.removeAttribute('id');
- return ReportMailSessionHistory;
+ return ReportMailSession;
};