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


module.exports = {
    tableName: 'scolarite',

    attributes: {
       /* id: {
        type: 'number',
        //columnName: 'id',
        unique: true,
        autoIncrement: true,
        primaryKey: true,
        //required: true,
        columnType: 'integer',
    },*/
        codeEcole: {
            type: 'string',
            columnName: 'code_ecole',
            required: true,
        },
        codeClasse: {
            type: 'string',
            columnName: 'code_classe',
            required: true,
        },
        
        matricule: {
            type: 'string',
            columnName: 'matricule',
            required: true,
        },
        anneeScolaire: {
            type: 'string',
            columnName: 'annee_scolaire',
            required: true,
        },

        montalTotal: {
            type: 'string',
            columnName: 'montant_total',
            required: true,
            //columnType: 'bigint'
        },

        montantRemise: {
            type: 'string',
            columnName: 'montant_remise',
            allowNull: true

        },

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

        },

        codeNatureRecette: {
            type: 'string',
            columnName: 'code_nature_recette',
            allowNull: true

        },
        libelle: {
            type: 'string',
            columnName: 'libelle',
            allowNull: true

        },
              
    },

};

