smc_cet_mainapp_backend/app/models/ApplicantsRelationship.js
2022-03-26 17:22:17 +05:30

36 lines
1.1 KiB
JavaScript

'use strict'
const { Model } = require('sequelize')
module.exports = (sequelize, DataTypes) => {
class ApplicantsRelationship extends Model {
}
ApplicantsRelationship.init(
{
loan_no_id: { type: DataTypes.INTEGER },
losid: { type: DataTypes.STRING },
applicant_id: { type: DataTypes.INTEGER },
name_of_the_individual: { type: DataTypes.STRING },
related_to: { type: DataTypes.STRING },
relationship: { type: DataTypes.STRING },
is_main_person_running_the_business: { type: DataTypes.STRING },
no_of_years_in_this_entity: { type: DataTypes.INTEGER },
no_of_years_in_same_line_of_buss: { type: DataTypes.INTEGER },
dob: { type: DataTypes.DATEONLY },
age: { type: DataTypes.INTEGER },
gender: { type: DataTypes.STRING },
remarks: { type: DataTypes.STRING },
is_active : { type: DataTypes.INTEGER },
createdBy: { type: DataTypes.INTEGER },
updatedBy: { type: DataTypes.INTEGER },
},
{
sequelize,
tableName: 'applicants_relationships',
modelName: 'ApplicantsRelationship',
}
)
return ApplicantsRelationship
}