43 lines
1.5 KiB
JavaScript
43 lines
1.5 KiB
JavaScript
'use strict'
|
|
const { Model } = require('sequelize')
|
|
module.exports = (sequelize, DataTypes) => {
|
|
class CreditLoanDetail extends Model {
|
|
|
|
}
|
|
CreditLoanDetail.init(
|
|
{
|
|
pd_id: { type: DataTypes.INTEGER },
|
|
loan_amount: { type: DataTypes.INTEGER }, // gen info
|
|
remarks_fund_source_balance: { type: DataTypes.STRING },
|
|
loan_tenure: { type: DataTypes.INTEGER },
|
|
sub_product: { type: DataTypes.STRING },
|
|
end_use: { type: DataTypes.STRING },
|
|
total_fund_requirement: { type: DataTypes.INTEGER },
|
|
is_transfer: { type: DataTypes.STRING },
|
|
balance_transfer_amount: { type: DataTypes.INTEGER },
|
|
lender: { type: DataTypes.STRING },
|
|
topup_amount: { type: DataTypes.INTEGER },
|
|
property_type: { type: DataTypes.STRING },
|
|
owner_name: { type: DataTypes.STRING },
|
|
construction_status: { type: DataTypes.STRING },
|
|
construction_stage: { type: DataTypes.STRING },
|
|
emv_per_customer: { type: DataTypes.INTEGER },
|
|
ltv_market_value_calculation: { type: DataTypes.INTEGER },
|
|
address: { type: DataTypes.STRING },
|
|
property_usage: { type: DataTypes.STRING },
|
|
structure_type: { type: DataTypes.STRING },
|
|
common_remarks: { type: DataTypes.STRING },
|
|
createdby: { type: DataTypes.INTEGER },
|
|
updatedby: { type: DataTypes.INTEGER }
|
|
|
|
},
|
|
{
|
|
sequelize,
|
|
tableName: 'credit_loan_details',
|
|
modelName: 'CreditLoanDetail',
|
|
}
|
|
)
|
|
|
|
|
|
return CreditLoanDetail
|
|
} |