'use strict'
const { Model } = require('sequelize')
module.exports = (sequelize, DataTypes) => {
  class ClientDetail extends Model {
   
  }
  ClientDetail.init(
    {
        pd_id: { type: DataTypes.INTEGER },
        client_info_available: { type:  DataTypes.STRING },
        client_not_available_reason: { type:  DataTypes.STRING },
        provider_name: { type:  DataTypes.STRING },
        client_name: { type:  DataTypes.INTEGER },
        contact_person_name: { type:  DataTypes.STRING },
        contact_person_designation: { type:  DataTypes.INTEGER },
        contact_person_mobile_no: { type:  DataTypes.STRING },
        person_stdcode: { type:  DataTypes.STRING },
        person_landline: { type:  DataTypes.INTEGER },
        payment_type: { type:  DataTypes.INTEGER },
        credit_period_no: { type:  DataTypes.INTEGER },
        credit_total_purchase: { type:  DataTypes.INTEGER },
        payment_mode: { type:  DataTypes.STRING },
        company_name: { type:  DataTypes.INTEGER },
        common_remarks: { type:  DataTypes.STRING },
        createdby: { type:  DataTypes.INTEGER },
        updatedby: { type:  DataTypes.INTEGER },
        type_of_payment : { type:  DataTypes.STRING },   // new
        name_of_the_company: { type:  DataTypes.STRING }, // new

        
    },
    {
      sequelize,
      tableName: 'credit_clients_details',
      modelName: 'ClientDetail',
    }
  )


  return ClientDetail
}