/**
 * 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_note_moyenne',

    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,

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

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

        },
       
        libelleCourt: {
            type: 'string',
            columnName: 'libelle_court',
           required: true,

        },

        libelleLong: {
            type: 'string',
            columnName: 'libelle_long',
            allowNull: true

        },
        typeNote: {
            type: 'string',
            columnName: 'type_note',
            allowNull: true

        },

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


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


        },
        moyenneCoef: {
            type: 'string',
            columnName: 'moyenne_coef',
            allowNull: true,
            //columnType: 'bigint'



        },

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


        },

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


        },

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


        },
        faibleMoyenne: {
            type: 'string',
            columnName: 'faible_moyenne',
            allowNull: true,
            //columnType: 'bigint'


        },

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


        },

        appreciationProf: {
            type: 'string',
            columnName: 'appreciation_prof',
            allowNull: true

        },

        anneeScolaire: {
            type: 'string',
            columnName: 'annee_scolaire',
            allowNull: true

        },

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

        },

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

        },

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

        },

       
    },

};

