2 var moment = require('moment');
4 module.exports = function(sequelize, DataTypes) {
5 var VoiceVoicemailMessages = sequelize.define('VoiceVoicemailMessages', {
7 type: DataTypes.INTEGER(11),
12 type: DataTypes.STRING,
16 type: DataTypes.STRING,
20 type: DataTypes.STRING,
24 type: DataTypes.STRING,
28 type: DataTypes.STRING,
32 type: DataTypes.STRING,
36 type: DataTypes.STRING,
40 type: DataTypes.STRING,
44 type: DataTypes.BLOB('long'),
48 type: DataTypes.STRING,
52 type: DataTypes.STRING,
61 defaultValue: sequelize.fn('NOW'),
63 // 'this' allows you to access attributes of the instance
64 return moment(this.getDataValue('createdAt')).format("MM-DD-YYYY HH:mm").toString();
69 defaultValue: sequelize.fn('NOW'),
71 // 'this' allows you to access attributes of the instance
72 return moment(this.getDataValue('updatedAt')).format("MM-DD-YYYY HH:mm").toString();
76 tableName: 'voice_voicemail_messages',
77 associate: function(models) {
78 VoiceVoicemailMessages.belongsTo(models.VoiceVoicemail, {
79 "foreignKey": "mailboxuser",
80 "targetKey": "mailbox"
82 VoiceVoicemailMessages.addScope('mailbox', function(query) {
86 if (query.context && query.mailbox) {
88 scope.where.mailboxcontext = query.context;
89 scope.where.mailboxuser = query.mailbox;
103 return VoiceVoicemailMessages;