53 lines
2.1 KiB
JavaScript
53 lines
2.1 KiB
JavaScript
'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
|
|
} |