smc_cet_creditpd_backend/app/models/BusinessAsset.js
suseendhiran17 62143d7898 susee
2023-08-09 14:34:06 +05:30

53 lines
2.3 KiB
JavaScript

'use strict'
const { Model } = require('sequelize')
module.exports = (sequelize, DataTypes) => {
class BusinessAsset extends Model {
}
BusinessAsset.init(
{
pd_id: { type: DataTypes.INTEGER },
initiated_address: { type: DataTypes.STRING },
is_business_address: { type: DataTypes.STRING },
business_months: { type: DataTypes.INTEGER },
business_years: { type: DataTypes.INTEGER },
business_is_pd_visited: { type: DataTypes.STRING },
business_pd_visited_remark: { type: DataTypes.STRING },
business_ownership_type: { type: DataTypes.STRING },
business_approximate_market_value: { type: DataTypes.INTEGER },
business_name_of_the_owner: { type: DataTypes.STRING },
business_vintage: { type: DataTypes.INTEGER },
business_purchase_year: { type: DataTypes.INTEGER },
business_emi: { type: DataTypes.INTEGER },
business_monthly_rented_amt: { type: DataTypes.INTEGER },
asset_info_available: { type: DataTypes.STRING },
business_assets_mode: { type: DataTypes.STRING },
other_asset_description: { type: DataTypes.STRING },
company_name: { type: DataTypes.STRING },
business_assets_mode_name: { type: DataTypes.STRING },
business_owner_name: { type: DataTypes.STRING },
business_ownership_type_master: { type: DataTypes.STRING },
business_name_of_the_owner_master: { type: DataTypes.STRING },
business_months_master: { type: DataTypes.STRING },
business_approximate_market_value_master: { type: DataTypes.STRING },
business_vintage_master: { type: DataTypes.STRING },
business_purchase_year_master: { type: DataTypes.STRING },
business_emi_master: { type: DataTypes.STRING },
business_owner_name_master: { type: DataTypes.STRING },
business_years_master: { type: DataTypes.STRING },
createdby: { type: DataTypes.INTEGER },
updatedby: { type: DataTypes.INTEGER },
display_order: { type: DataTypes.INTEGER },
business_monthly_rented_amt_master: { type: DataTypes.STRING }
},
{
sequelize,
tableName: 'credit_business_assets',
modelName: 'BusinessAsset',
}
)
return BusinessAsset
}