database_models_Client.js

const Sequelize = require('sequelize');
/**
 * @typedef Client
 * @property {{type: Sequelize.STRING, trim: true}}  denominationSocial                        - La Dénomination sociale du client.
 * @property {{type: Sequelize.STRING, trim: true}}  rcs                                       - Le registre du commerce et des sociétés du client.
 * @property {{type: Sequelize.STRING, trim: true}}  siret                                     - Le système d'identification du répertoire des établissements du client. 
 * @property {{type: Sequelize.STRING, trim: true}}  president                                 - Le nom complet du président.
 * @property {{type: Sequelize.STRING, trim: true}}  tvaIntracom                               - La Taxe sur la valeur ajoutée Inter-communautaire. 
 * @property {{type: Sequelize.STRING, trim: true}}  address                                   -  L'adresse du client.
 * @property {{type: Sequelize.STRING, trim: true}}  zipCode                                   -  Le zipCode du client.
 * @property {{type: Sequelize.STRING, trim: true}}  city                                      - La ville de résidence du client.
 * @property {{type: Sequelize.STRING, trim: true}}  contact                                   - Le contact (Nom Prénom) du client.
 * @property {{type: Sequelize.STRING, trim: true}}  contactPhone                              - Le numéro du client.
 * @property {{type: Sequelize.STRING, trim: true}}  contactMail                               -  L'email du client.
 * @property {{type: Sequelize.TEXT, trim: true}}  observation                                 - Observation générale du client 
 *
 * @memberof Myintranet.Database
 */

module.exports = {
    denominationSocial: {type: Sequelize.STRING, trim: true,uppercase:true},
    rcs: {type: Sequelize.STRING, trim: true},
    siret: {type: Sequelize.STRING, trim: true},

    president: {type: Sequelize.STRING, trim: true, capitalizeOnSpace:true},
    tvaIntracom: {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},
    contact: {type: Sequelize.STRING, trim: true, capitalizeOnSpace:true},
    contactPost: {type: Sequelize.STRING, trim: true},
    contactPhone: {type: Sequelize.STRING, trim: true},
    contactMail: {type: Sequelize.STRING, trim: true},
    escompte: {type: Sequelize.TEXT, trim: true},
    escompteDelay: {type: Sequelize.TEXT, trim: true},
    observation: {type: Sequelize.TEXT, trim: true},
}