var moment = require('moment');
module.exports = function(sequelize, DataTypes) {
- var ReportMailRoom = sequelize.define('ReportSmsRoom', {
- uniqueid: {
- type: DataTypes.STRING,
- unique: true
- },
+ var ReportOpenchannelSessionHistory = sequelize.define('ReportOpenchannelSessionHistory', {
+ uniqueid: DataTypes.STRING,
accountid: DataTypes.STRING,
accountname: DataTypes.STRING,
accountnumber: DataTypes.STRING,
application: DataTypes.STRING,
- from: DataTypes.STRING,
memberid: DataTypes.STRING,
membername: DataTypes.STRING,
queue: DataTypes.INTEGER,
queuename: DataTypes.STRING,
roomid: DataTypes.INTEGER,
+ fidelity: {
+ type: DataTypes.INTEGER,
+ defaultValue: 0
+ },
+ joinAt: DataTypes.DATE,
+ leaveAt: DataTypes.DATE,
+ completeAt: DataTypes.DATE,
complete: {
type: DataTypes.BOOLEAN,
defaulValue: false
},
completeReason: DataTypes.ENUM('agent'),
- completeAt: DataTypes.DATE,
- joinAt: DataTypes.DATE,
- leaveAt: DataTypes.DATE,
unmanaged: {
type: DataTypes.BOOLEAN,
defaultValue: false
- },
- disposition: DataTypes.STRING,
- note: DataTypes.TEXT,
- urating: {
- type: DataTypes.INTEGER,
- defaultValue: 0,
- validate: {
- min: 0,
- max: 10
- }
- },
- status: {
- type: DataTypes.ENUM('NEW', 'OPEN', 'CLOSED', 'UNMANAGED'),
- defaultValue: 'NEW'
- },
+ }
}, {
- tableName: 'report_sms_room'
+ tableName: 'report_openchannel_session_history'
});
-
- return ReportMailRoom;
+ ReportOpenchannelSessionHistory.removeAttribute('id');
+ return ReportOpenchannelSessionHistory;
};