database_models_Consultant.js

const Sequelize = require('sequelize');
/**
 * @typedef consultant
 * @property {Sequelize.DATE}  birthDate                     - La date de naissance du consultant.
 * @property {Sequelize.DATE}  birthPlace                   - Le lieu de naissance du consultant.
 * @property {{type: Sequelize.STRING, trim: true}}  secuNum                   - Le numéro de sécurité du consultant.
 * @property {{type: Sequelize.STRING, trim: true}}  address                        - L'adresse du consultant.
 * @property {{type: Sequelize.STRING, trim: true}}  zipCode                     - Le code postal du consultant.
 * @property {{type: Sequelize.STRING, trim: true}}  city                        - La ville ou réside le consultant.
 * @property {{type: Sequelize.TEXT, trim: true}}  observation                        - L'observation génerale du consultant 
 * @property {Myintranet.Database.User}  Utilisateur         - L'utilisateur associé si on l'include dans la requette 
 * @memberof Myintranet.Database
 */
module.exports = {

    birthDate: Sequelize.DATEONLY,
    birthPlace:  {type: Sequelize.STRING, trim: true},
    codePlace: {type: Sequelize.STRING, trim: true},
    secuNum: {type: Sequelize.STRING, trim: true},
    address: {type: Sequelize.STRING, trim: true},
    zipCode: {type: Sequelize.STRING, trim: true},
    city: {type: Sequelize.STRING, trim: true,uppercase:true},
    status: {type: Sequelize.STRING, trim: true},    // SUBSCRIBED || VALID || PRESUB
    observation: {type: Sequelize.TEXT, trim: true},
    foldername:{type: Sequelize.STRING, trim: true}


}