4 * Report Chat Room Log Model
7 var moment = require('moment');
9 module.exports = function(sequelize, DataTypes) {
11 var ReportChatRoom = sequelize.define('ReportChatRoom', {
13 type: DataTypes.STRING,
16 websitename: DataTypes.STRING,
17 websiteaddress: DataTypes.STRING,
18 websiteid: DataTypes.INTEGER,
19 application: DataTypes.STRING,
20 visitorid: DataTypes.STRING,
21 visitorname: DataTypes.STRING,
22 visitoremail: DataTypes.STRING,
23 memberid: DataTypes.STRING,
24 membername: DataTypes.STRING,
25 queueid: DataTypes.INTEGER,
26 queuename: DataTypes.STRING,
27 roomid: DataTypes.INTEGER,
28 data1: DataTypes.STRING,
29 data2: DataTypes.STRING,
30 data3: DataTypes.STRING,
31 labelData1: DataTypes.STRING,
32 labelData2: DataTypes.STRING,
33 labelData3: DataTypes.STRING,
35 type: DataTypes.BOOLEAN,
39 type: DataTypes.BOOLEAN,
42 completeReason: DataTypes.ENUM('agent', 'requester'),
43 completeAt: DataTypes.DATE,
44 joinAt: DataTypes.DATE,
45 leaveAt: DataTypes.DATE,
47 type: DataTypes.BOOLEAN,
50 disposition: DataTypes.STRING,
53 type: DataTypes.INTEGER,
60 crating: DataTypes.ENUM('good', 'bad'),
61 cratingMessage: DataTypes.TEXT
63 tableName: 'report_chat_room'
66 return ReportChatRoom;