ms_soccer_club_rank.js 2.4 KB
/* jshint indent: 2 */
module.exports = function (sequelize, DataTypes) {
    return sequelize.define('ms_soccer_club_rank', {
        club_id: {
            type: DataTypes.BIGINT,
            allowNull: false,
            primaryKey: true
        },
        club_name: {
            type: DataTypes.STRING(50),
            allowNull: true
        },
        club_url: {
            type: DataTypes.STRING(255),
            allowNull: true
        },
        find_player_url: {
            type: DataTypes.STRING(150),
            allowNull: true
        },
        national_id: {
            type: DataTypes.BIGINT,
            allowNull: true
        },
        national_name: {
            type: DataTypes.STRING(50),
            allowNull: true
        },
        national_url: {
            type: DataTypes.STRING(255),
            allowNull: true
        },
        area5: {
            type: DataTypes.STRING(20),
            allowNull: true
        },
        area4: {
            type: DataTypes.STRING(20),
            allowNull: true
        },
        area3: {
            type: DataTypes.STRING(20),
            allowNull: true
        },
        area2: {
            type: DataTypes.STRING(20),
            allowNull: true
        },
        current_area1: {
            type: DataTypes.STRING(20),
            allowNull: true
        },
        points: {
            type: DataTypes.STRING(20),
            allowNull: true
        },
        update_flag: {
            type: DataTypes.INTEGER(1),
            allowNull: false,
            defaultValue: '0'
        },
        player_update: {
            type: DataTypes.INTEGER(1),
            allowNull: false,
            defaultValue: '0'
        },
        created_at: {
            type: DataTypes.BIGINT,
            allowNull: true
        },
        updated_at: {
            type: DataTypes.BIGINT,
            allowNull: true
        },
        chinese_club_name: {
            type: DataTypes.STRING(50),
            allowNull: true,
            defaultValue: ''
        },
        chinese_national_name: {
            type: DataTypes.STRING(50),
            allowNull: true,
            defaultValue: ''
        },
        index_number: {
            type: DataTypes.INTEGER(11),
            allowNull: false,
            defaultValue: '0'
        }
    }, {
        tableName: 'ms_soccer_club_rank'
    });
};
//# sourceMappingURL=ms_soccer_club_rank.js.map