ms_message.ts 1.4 KB
module.exports = function(sequelize:any, DataTypes:any) {
    return sequelize.define('ms_message', {
      message_id: {
        type: DataTypes.STRING(50),
        allowNull: false,
        primaryKey: true
      },
      message_title: {
        type: DataTypes.STRING(500),
        allowNull: true
      },
      message_subtitle: {
        type: DataTypes.STRING(500),
        allowNull: true
      },
      message_type: {
        type: DataTypes.STRING(20),
        allowNull: true
      },
      created_at: {
        type: DataTypes.DATE,
        allowNull: true
      },
      updated_at: {
        type: DataTypes.DATE,
        allowNull: true
      },
      operation_user_id: {
        type: DataTypes.INTEGER(11),
        allowNull: true
      },
      publish_time: {
        type: DataTypes.DATE,
        allowNull: true
      },
      target_user: {
        type: DataTypes.JSON,
        allowNull: true
      },
      message_target_type: {
        type: DataTypes.STRING(20),
        allowNull: true
      },
      app_version: {
        type: DataTypes.STRING(20),
        allowNull: true
      },
      message_target_url: {
        type: DataTypes.STRING(500),
        allowNull: true
      },
      message_status: {
        type: DataTypes.STRING(10),
        allowNull: true
      },
      message_body: {
        type: DataTypes.JSON,
        allowNull: true
      }
    }, {
      tableName: 'ms_message'
    });
  };