/**
 * Role.js
 *
 * @description :: A model definition represents a database table/collection.
 * @docs        :: https://sailsjs.com/docs/concepts/models-and-orm/models
 */


module.exports = {
    tableName: 'attribution_rang',

    attributes: {
        /* id: {
        type: 'number',
        //columnName: 'id',
        unique: true,
        autoIncrement: true,
        primaryKey: true,
        //required: true,
        columnType: 'integer',
    },*/

        codeMatiere: {
            type: 'string',
            columnName: 'code_matiere',
           // required: true,

        },

        codeEcole: {
            type: 'string',
            columnName: 'code_ecole',
            required: true,

        },
        anneeScolaire: {
            type: 'string',
            columnName: 'annee_scolaire',
            required: true,

        },
        
        codeClasse: {
            type: 'string',
            columnName: 'code_classe',
            required: true,

        },
       
        dateEvaluation: {
            //type: 'string',
            type: 'ref',
            //columnType:'datetime',
            columnName: 'date_evaluation',
            //allowNull: true

        },

        moyennePeriodique: {
            type: 'string',
            //columnType: 'bigint',
            columnName: 'moyenne_periodique',
            allowNull: true

        },
        moyenneBilanLettre: {
            type: 'string',
            //columnType: 'bigint',
            columnName: 'moyenne_bilan_lettre',
            allowNull: true

        },

        appreciationBilanLettre: {
            type: 'string',
            columnName: 'appreciation_bilan_lettre',
            allowNull: true

        },
        moyenneBilanSciences: {
            type: 'string',
            //columnType: 'bigint',
            columnName: 'moyenne_bilan_sciences',
            allowNull: true

        },
        appreciationBilanSciences: {
            type: 'string',
            columnName: 'appreciation_bilan_sciences',
            allowNull: true,
        },

        moyenneBilanAutres: {
            type: 'string',
            //columnType: 'bigint',
            columnName: 'moyenne_bilan_autres',
            allowNull: true

        },

        appreciationBilanAutres: {
            type: 'string',
            columnName: 'appreciation_bilan_autres',
            allowNull: true,
        },

        appreciationChefEtab: {
            type: 'string',
            columnName: 'appreciation_chef_etab',
            allowNull: true

        },
        appreciationPp: {
            type: 'string',
            columnName: 'appreciation_pp',
            allowNull: true

        },

        mentionConseilProf: {
            type: 'string',
            columnName: 'mention_conseil_prof',
            allowNull: true

        },

        statusPassant: {
            type: 'string',
            columnName: 'status_passant',
            allowNull: true

        },

        totalCoef: {
            type: 'string',
            //columnType: 'bigint',
            columnName: 'total_coef',
            allowNull: true

        },

        totalMoyenne: {
            type: 'string',
            //columnType: 'bigint',
            columnName: 'total_moyenne',
            allowNull: true

        },

        moyenneFaible: {
            type: 'string',
           // columnType: 'bigint',
            columnName: 'moyenne_faible',
            allowNull: true,
        },

        moyenneForte: {
            type: 'string',
            //columnType: 'bigint',
            columnName: 'moyenne_forte',
            allowNull: true,
        },

        moyenneClasse: {
            type: 'string',
            //columnType: 'bigint',
            columnName: 'moyenne_classe',
            allowNull: true,
        },

        trimSem: {
            type: 'string',
            columnName: 'trim_sem',
            allowNull: true

        },

        rang: {
            type: 'string',
            columnName: 'rang',
            allowNull: true,
            //columnType: 'bigint'

        },
        matricule: {
            type: 'string',
            columnName: 'matricule',
            //required: true,

        },

       
    },

};

