ms_soccer_base_surface.ts 3.3 KB
/* jshint indent: 2 */

module.exports = function (sequelize: any, DataTypes: any) {
  return sequelize.define('ms_soccer_base_surface', {
    id: {
      type: DataTypes.INTEGER(11),
      allowNull: false,
      primaryKey: true,
      autoIncrement: true
    },
    yiqiu_id: {
      type: DataTypes.INTEGER(11),
      allowNull: false,
      unique: true
    },
    sport_id: {
      type: DataTypes.INTEGER(11),
      allowNull: false,
      unique: true
    },
    home_team_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    away_team_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    match_time: {
      type: DataTypes.STRING(100),
      allowNull: true
    },
    competition_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    competition_name: {
      type: DataTypes.STRING(200),
      allowNull: true
    },
    home_name: {
      type: DataTypes.STRING(200),
      allowNull: true
    },
    away_name: {
      type: DataTypes.STRING(200),
      allowNull: true
    },
    week_day: {
      type: DataTypes.STRING(20),
      allowNull: true
    },
    home_point: {
      type: DataTypes.INTEGER(11),
      allowNull: true,
      defaultValue: '0'
    },
    away_point: {
      type: DataTypes.INTEGER(11),
      allowNull: true,
      defaultValue: '0'
    },
    home_rank: {
      type: DataTypes.INTEGER(11),
      allowNull: true,
      defaultValue: '0'
    },
    away_rank: {
      type: DataTypes.INTEGER(11),
      allowNull: true,
      defaultValue: '0'
    },
    is_jingcai: {
      type: DataTypes.INTEGER(11),
      allowNull: true,
      defaultValue: '0'
    },
    is_beidan: {
      type: DataTypes.INTEGER(11),
      allowNull: true,
      defaultValue: '0'
    },
    issue_name_jc: {
      type: DataTypes.STRING(100),
      allowNull: true
    },
    issue_name_bd: {
      type: DataTypes.STRING(100),
      allowNull: true
    },
    radar_chart_data: {
      type: DataTypes.JSON,
      allowNull: true
    },
    status_analysis: {
      type: DataTypes.JSON,
      allowNull: true
    },
    point_rank_message: {
      type: DataTypes.JSON,
      allowNull: true
    },
    point_rank_trend: {
      type: DataTypes.JSON,
      allowNull: true
    },
    result_analysis: {
      type: DataTypes.JSON,
      allowNull: true
    },
    ah_odd_analysis: {
      type: DataTypes.JSON,
      allowNull: true
    },
    hda_kelly_odd: {
      type: DataTypes.JSON,
      allowNull: true
    },
    hda_changes_total: {
      type: DataTypes.JSON,
      allowNull: true
    },
    hda_analysis: {
      type: DataTypes.JSON,
      allowNull: true
    },
    score: {
      type: DataTypes.STRING(20),
      allowNull: true
    },
    letball: {
      type: DataTypes.STRING(20),
      allowNull: true
    },
    half: {
      type: DataTypes.STRING(20),
      allowNull: true
    },
    match_result: {
      type: DataTypes.JSON,
      allowNull: true
    },
    predict_result: {
      type: DataTypes.JSON,
      allowNull: true
    },
    same_odds_result: {
      type: DataTypes.JSON,
      allowNull: true
    },
    match_num: {
      type: DataTypes.STRING(20),
      allowNull: true
    },
    handicap: {
      type: DataTypes.STRING(20),
      allowNull: true,
      defaultValue: '0'
    },
  }, {
    tableName: 'ms_soccer_base_surface'
  });
};