meetingModel.js 1.5 KB
var  sequelize = require('../config');
var Sequelize = require('sequelize');
const uuid = require('../util/UuidUtil')


var  user = sequelize.define('3m_meeting', {
    id: {
        type: Sequelize.STRING(32),
        defaultValue:uuid.db32(),
        allowNull: false,
        unique: true,
        primaryKey: true,
        field: "id"
    },
    meetingNumber: {
        type:Sequelize.STRING(32),
        field: "meeting_number"
    },
    meetingName: {
        type:Sequelize.STRING(128),
        field: "meeting_name"
    },
    meetingContent:{
        type:Sequelize.TEXT(0),
        field: "meeting_content"
    },
    create_user:{
        type:Sequelize.STRING(128),
        field: "user_name"
    },
    createTime:{
        type:Sequelize.DATE,
        defaultValue:Sequelize.NOW,
        field: "create_time"
    },
    beginTime:{
        type:Sequelize.DATE,
        defaultValue:Sequelize.NOW,
        field: "begin_time"
    },
    endTime:{
        type:Sequelize.DATE,
        field: "end_time"
    },
    inviteUser:{
        type:Sequelize.STRING(1024),
        field: "invite_user"
    },
    meetingType:{
        type:Sequelize.INTEGER(4),
        field: "meeting_type"
    },
    meetingStatus:{
        type:Sequelize.STRING(32),
        field: "meeting_status"
    },
    userIp:{
        type:Sequelize.INTEGER(11),
        field: "user_ip"
    },
    meetingKey:{
        type:Sequelize.STRING(128),
        field: "meeting_key"
    },
}, {
        timestamps: false,
        freezeTableName: true
    });

module.exports = user;