sportdt_fifa_ranking.ts 1.9 KB
module.exports = function(sequelize:any, DataTypes:any) {
    return sequelize.define('sportdt_fifa_ranking', {
      id: {
        type: DataTypes.INTEGER(11),
        allowNull: false,
        primaryKey: true,
        autoIncrement: true
      },
      ranking: {
        type: DataTypes.INTEGER(11),
        allowNull: true
      },
      team_name: {
        type: DataTypes.STRING(50),
        allowNull: true
      },
      points: {
        type: DataTypes.STRING(50),
        allowNull: true
      },
      ranking_change: {
        type: DataTypes.STRING(50),
        allowNull: true
      },
      points_change: {
        type: DataTypes.STRING(50),
        allowNull: true
      },
      ranking_date: {
        type: DataTypes.STRING(50),
        allowNull: true
      },
      gender: {
        type: DataTypes.INTEGER(4),
        allowNull: true
      },
      created_at: {
        type: DataTypes.DATE,
        allowNull: true
      },
      updated_at: {
        type: DataTypes.DATE,
        allowNull: true
      },
      sort_id: {
        type: DataTypes.INTEGER(11),
        allowNull: true
      },
      sort_name: {
        type: DataTypes.STRING(100),
        allowNull: true
      },
      team_logo: {
        type: DataTypes.STRING(500),
        allowNull: true
      },
      team_id: {
        type: DataTypes.INTEGER(11),
        allowNull: true
      },
      team_type: {
        type: DataTypes.STRING(20),
        allowNull: true
      },
      ranking_change_font: {
        type: DataTypes.STRING(50),
        allowNull: true
      },
      points_change_font: {
        type: DataTypes.STRING(50),
        allowNull: true
      },
      yiqiu_team_id: {
        type: DataTypes.INTEGER(11),
        allowNull: true
      },
      yiqiu_team_name: {
        type: DataTypes.STRING(100),
        allowNull: true
      }
    }, {
      tableName: 'sportdt_fifa_ranking'
    });
  };