'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
}