5 var moment = require('moment');
7 module.exports = function(sequelize, DataTypes) {
9 var ReportChatRoomHistory = sequelize.define('ReportChatRoomHistory', {
11 type: DataTypes.STRING,
14 websitename: DataTypes.STRING,
15 websiteaddress: DataTypes.STRING,
16 websiteid: DataTypes.INTEGER,
17 application: DataTypes.STRING,
18 visitorid: DataTypes.STRING,
19 visitorname: DataTypes.STRING,
20 visitoremail: DataTypes.STRING,
21 memberid: DataTypes.STRING,
22 membername: DataTypes.STRING,
23 queueid: DataTypes.INTEGER,
24 queuename: DataTypes.STRING,
25 roomid: DataTypes.INTEGER,
26 data1: DataTypes.STRING,
27 data2: DataTypes.STRING,
28 data3: DataTypes.STRING,
29 labelData1: DataTypes.STRING,
30 labelData2: DataTypes.STRING,
31 labelData3: DataTypes.STRING,
33 type: DataTypes.BOOLEAN,
37 type: DataTypes.BOOLEAN,
40 completeReason: DataTypes.ENUM('agent', 'requester'),
41 completeAt: DataTypes.DATE,
42 joinAt: DataTypes.DATE,
43 leaveAt: DataTypes.DATE,
45 type: DataTypes.BOOLEAN,
48 disposition: DataTypes.STRING,
51 type: DataTypes.INTEGER,
58 crating: DataTypes.ENUM('good', 'bad'),
59 cratingMessage: DataTypes.TEXT
61 tableName: 'report_chat_room_history'
64 return ReportChatRoomHistory;