prediction_expert.ts 2.2 KB
/* jshint indent: 2 */

module.exports = function(sequelize:any, DataTypes:any) {
  return sequelize.define('prediction_expert', {
    expertid: {
      type: DataTypes.BIGINT,
      allowNull: false,
      primaryKey: true
    },
    author_name: {
      type: DataTypes.STRING(20),
      allowNull: true
    },
    author_tag: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    author_headimgurl: {
      type: DataTypes.STRING(100),
      allowNull: true
    },
    author_description: {
      type: DataTypes.STRING(500),
      allowNull: true
    },
    author_advantage: {
      type: DataTypes.STRING(500),
      allowNull: true
    },
    maxlzcount: {
      type: DataTypes.INTEGER(11),
      allowNull: true,
      defaultValue: '0'
    },
    record: {
      type: DataTypes.STRING(20),
      allowNull: true,
      defaultValue: '0000000'
    },
    lzcount: {
      type: DataTypes.INTEGER(11),
      allowNull: true,
      defaultValue: '0'
    },
    win_ratio: {
      type: DataTypes.STRING(50),
      allowNull: true,
      defaultValue: '0'
    },
    sum_win_count: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    sumcount: {
      type: DataTypes.INTEGER(11),
      allowNull: true,
      defaultValue: '0'
    },
    d7returnratio: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    d15returnratio: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    last7danreturn: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    lz_7count: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    lz_30d_count: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    d7_win_ratio: {
      type: DataTypes.STRING(10),
      allowNull: true
    },
    updated_at: {
      type: DataTypes.DATE,
      allowNull: true
    },
    created_at: {
      type: DataTypes.DATE,
      allowNull: true
    },
    record_month: {
      type: DataTypes.JSON,
      allowNull: true
    },
    author_7wincount: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    d30returnratio: {
      type: DataTypes.STRING(50),
      allowNull: true
    }
  }, {
    tableName: 'prediction_expert'
  });
};