coaches.js 2.3 KB
module.exports = function (sequelize, DataTypes) {
    return sequelize.define('coaches', {
        id: {
            autoIncrement: true,
            type: DataTypes.INTEGER,
            allowNull: false,
            primaryKey: true,
            comment: "教练ID"
        },
        age: {
            type: DataTypes.INTEGER,
            allowNull: true,
            comment: "年龄"
        },
        birthday: {
            type: DataTypes.INTEGER,
            allowNull: true,
            comment: "生日 (0-未知)"
        },
        contract_until: {
            type: DataTypes.INTEGER,
            allowNull: true,
            comment: "合同到期时间"
        },
        country_id: {
            type: DataTypes.INTEGER,
            allowNull: true,
            comment: "国家ID"
        },
        joined: {
            type: DataTypes.INTEGER,
            allowNull: true,
            comment: "加盟时间"
        },
        logo: {
            type: DataTypes.STRING(255),
            allowNull: true,
            comment: "教练Logo"
        },
        name_en: {
            type: DataTypes.STRING(255),
            allowNull: true,
            comment: "英文名称"
        },
        name_zh: {
            type: DataTypes.STRING(255),
            allowNull: true,
            comment: "中文名称"
        },
        name_zht: {
            type: DataTypes.STRING(255),
            allowNull: true,
            comment: "粤语名称"
        },
        nationality: {
            type: DataTypes.STRING(255),
            allowNull: true,
            comment: "国籍"
        },
        preferred_formation: {
            type: DataTypes.STRING(255),
            allowNull: true,
            comment: "习惯的阵型"
        },
        team_id: {
            type: DataTypes.INTEGER,
            allowNull: true,
            comment: "执教球队ID"
        },
        updated_at: {
            type: DataTypes.BIGINT,
            allowNull: true,
            get() {
                return moment(this.getDataValue('updated_at')).format('YYYY-MM-DD HH:mm:ss');
            }
        },
        created_at: {
            type: DataTypes.DATE,
            allowNull: true
        },
        type: {
            type: DataTypes.INTEGER(11),
            allowNull: true
        },
    });
};
//# sourceMappingURL=coaches.js.map