ms_article.ts 2.8 KB
/* jshint indent: 2 */

module.exports = function(sequelize:any, DataTypes:any) {
  return sequelize.define('ms_article', {
    uuid: {
      type: DataTypes.STRING(50),
      allowNull: false,
      primaryKey: true
    },
    created_at: {
      type: DataTypes.DATE,
      allowNull: true
    },
    updated_at: {
      type: DataTypes.DATE,
      allowNull: true
    },
    type_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    type_code: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    type_name: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    app_code: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    title: {
      type: DataTypes.STRING(200),
      allowNull: true
    },
    short_title: {
      type: DataTypes.STRING(100),
      allowNull: true
    },
    keywords: {
      type: DataTypes.STRING(100),
      allowNull: true
    },
    contents: {
      type: DataTypes.TEXT,
      allowNull: true
    },
    article_source: {
      type: DataTypes.STRING(100),
      allowNull: true
    },
    read_count: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    auther_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    auther_name: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    is_image: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    banner_image_url: {
      type: DataTypes.STRING(500),
      allowNull: true
    },
    background_image_url: {
      type: DataTypes.STRING(500),
      allowNull: true
    },
    pc_image_url: {
      type: DataTypes.STRING(500),
      allowNull: true
    },
    is_hot: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    is_show: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    tag: {
      type: DataTypes.STRING(100),
      allowNull: true
    },
    article_options: {
      type: DataTypes.JSON,
      allowNull: true
    },
    article_target_url: {
      type: DataTypes.STRING(500),
      allowNull: true
    },
    effective_begin_date: {
      type: DataTypes.DATE,
      allowNull: true
    },
    effective_end_date: {
      type: DataTypes.DATE,
      allowNull: true
    },
    article_target_type: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    version: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    effective_type: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    effective_weekly_day: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    effective_daily_begin_time: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    effective_daily_end_time: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    sub_code: {
      type: DataTypes.STRING(50),
      allowNull: true
    }
  }, {
    tableName: 'ms_article'
  });
};