'use strict'
const { Model } = require('sequelize')
module.exports = (sequelize, DataTypes) => {
  class LoanDetail extends Model {
   
  }
  LoanDetail.init(
    {
        losid: { type:  DataTypes.STRING },
        // applicationNo: { type:  DataTypes.INTEGER },
        product : { type:  DataTypes.STRING },
        date_of_login: { type:  DataTypes.INTEGER },
        sourcing_channel_type: { type:  DataTypes.STRING },
        sourcing_channel_name: { type:  DataTypes.STRING },
        proposal: { type:  DataTypes.INTEGER },
        sanction_date_of_earlier_exposure: { type:  DataTypes.STRING },
        sanction_amount_of_earlier_exposure: { type:  DataTypes.INTEGER },
        current_outstnd_bal_of_earlier_exposure: { type:  DataTypes.INTEGER },
        emi_of_earlier_exposure: { type:  DataTypes.INTEGER },
        additional_loan_amnt_applied_for: { type:  DataTypes.INTEGER },
        insurance_premium_amnt_being_funded: { type:  DataTypes.INTEGER },
        insurance_premium_loan_applied_for: { type:  DataTypes.INTEGER },
        additional_loan_amnt_applied_for_and_insu_premium: { type:  DataTypes.INTEGER },
        load_tenure_applied_for_months: { type:  DataTypes.INTEGER },
        rate_of_interest_per_annum: { type:  DataTypes.INTEGER },
        emi_per_lac_of_loan: { type:  DataTypes.INTEGER },
        purpose_of_loan: { type:  DataTypes.INTEGER },
        specify_other_business_need : { type:  DataTypes.STRING },
        emi_of_loan_applied_for: { type:  DataTypes.INTEGER },
        pd_id: { type:  DataTypes.STRING },
        module_completion_status : { type:  DataTypes.INTEGER },
        createdby: { type:  DataTypes.INTEGER },
        updatedby: { type:  DataTypes.INTEGER },
        is_active: {type : DataTypes.INTEGER}
    },
    {
      sequelize,
      tableName: 'loan_details',
      modelName: 'LoanDetail',
    }
  )
  LoanDetail.associate = models => {
    LoanDetail.hasMany(models.ApplicantsDetails,  {
      foreignKey: 'loan_no_id',
      sourceKey : 'id'
    });
    LoanDetail.hasMany(models.EntityDetails,  {
      foreignKey: 'loan_no_id',
      sourceKey : 'id'
    });
  }
  return LoanDetail
}