ms_basketball_game.ts 8.1 KB
/* jshint indent: 2 */

module.exports = function (sequelize:any, DataTypes:any) {
  return sequelize.define('ms_basketball_game', {
    id: {
      type: DataTypes.BIGINT,
      allowNull: false,
      primaryKey: true,
      autoIncrement: true
    },
    created_at: {
      type: DataTypes.DATE,
      allowNull: true
    },
    updated_at: {
      type: DataTypes.DATE,
      allowNull: true
    },
    n: {
      type: DataTypes.INTEGER(11),
      allowNull: true,
      defaultValue: '0'
    },
    city: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    date: {
      type: DataTypes.BIGINT,
      allowNull: true
    },
    aodds: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    bodds: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    round: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    channel: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    referee: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    handicap: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    round_name: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    ascore: {
      type: DataTypes.JSON,
      allowNull: true
    },
    bscore: {
      type: DataTypes.JSON,
      allowNull: true
    },
    home_team: {
      type: DataTypes.JSON,
      allowNull: true
    },
    away_team: {
      type: DataTypes.JSON,
      allowNull: true
    },
    competition: {
      type: DataTypes.JSON,
      allowNull: true
    },
    sportsdt_competition_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    competition_name: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    competition_short_name: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    competition_color: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    sportsdt_host_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    host_name: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    host_short_name: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    host_rank: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    host_photo: {
      type: DataTypes.STRING(500),
      allowNull: true
    },
    sportsdt_away_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    away_name: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    away_short_name: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    away_rank: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    away_photo: {
      type: DataTypes.STRING(500),
      allowNull: true
    },
    status: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    score: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    red_card: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    yellow_card: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    score_all: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    score_point: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    half: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    local_time: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    sports_info: {
      type: DataTypes.JSON,
      allowNull: true
    },
    dfcp_img_url: {
      type: DataTypes.STRING(500),
      allowNull: true
    },
    sports_video_info: {
      type: DataTypes.JSON,
      allowNull: true
    },
    total_info: {
      type: DataTypes.INTEGER(11),
      allowNull: true,
      defaultValue: '0'
    },
    info_point: {
      type: DataTypes.INTEGER(11),
      allowNull: true,
      defaultValue: '0'
    },
    info_source_game_id: {
      type: DataTypes.JSON,
      allowNull: true
    },
    info_check_flag: {
      type: DataTypes.INTEGER(11),
      allowNull: true,
      defaultValue: '0'
    },
    note: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    sportsdt_game_id: {
      type: DataTypes.BIGINT,
      allowNull: true,
      unique: true
    },
    weather: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    spectator: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    capacity: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    stadium: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    first_quarter: {
      type: DataTypes.JSON,
      allowNull: true
    },
    second_quarter: {
      type: DataTypes.JSON,
      allowNull: true
    },
    three_quarter: {
      type: DataTypes.JSON,
      allowNull: true
    },
    four_quarter: {
      type: DataTypes.JSON,
      allowNull: true
    },
    info_match_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true,
      defaultValue: '0'
    },
    info_competition_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true,
      defaultValue: '0'
    },
    info_host_team_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true,
      defaultValue: '0'
    },
    info_guest_team_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true,
      defaultValue: '0'
    },
    sporttery_match_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true,
      defaultValue: '0'
    },
    sporttery_competition_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true,
      defaultValue: '0'
    },
    sporttery_host_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true,
      defaultValue: '0'
    },
    sporttery_guest_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true,
      defaultValue: '0'
    },
    leisu_competition_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true,
      defaultValue: '0'
    },
    leisu_match_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true,
      defaultValue: '0'
    },
    leisu_host_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true,
      defaultValue: '0'
    },
    leisu_guest_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true,
      defaultValue: '0'
    },
    isah: {
      type: DataTypes.INTEGER(11),
      allowNull: true,
      defaultValue: '0'
    },
    yiqiu_host_team_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    yiqiu_host_team_name: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    yiqiu_host_team_short_name: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    yiqiu_host_team_logo: {
      type: DataTypes.STRING(500),
      allowNull: true
    },
    yiqiu_guest_team_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    yiqiu_guest_team_name: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    yiqiu_guest_team_short_name: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    yiqiu_guest_team_logo: {
      type: DataTypes.STRING(500),
      allowNull: true
    },
    yiqiu_competition_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    yiqiu_competition_name: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    yiqiu_competition_short_name: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    yiqiu_competition_logo: {
      type: DataTypes.STRING(200),
      allowNull: true
    },
    is_jingcai: {
      type: DataTypes.INTEGER(11),
      allowNull: true,
      defaultValue: '0'
    },
    sporttery_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    sporttery_issue_name: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    sporttery_number: {
      type: DataTypes.STRING(10),
      allowNull: true
    },
    match_time: {
      type: DataTypes.DATE,
      allowNull: true
    },
    yiqiu_competition_season: {
      type: DataTypes.STRING(20),
      allowNull: true
    },
    yiqiu_competition_round: {
      type: DataTypes.STRING(20),
      allowNull: true
    },
    yiqiu_competition_mode: {
      type: DataTypes.STRING(20),
      allowNull: true
    },
    yiqiu_competition_round_item: {
      type: DataTypes.STRING(20),
      allowNull: true
    }
  }, {
    tableName: 'ms_basketball_game'
  });
};