'use strict'
const { Model } = require('sequelize')
module.exports = (sequelize, DataTypes) => {
  class CreditFinancialAnalysis extends Model {
   
  }
  CreditFinancialAnalysis.init(
    {
        pd_id: { type: DataTypes.INTEGER },
        car_type: { type:  DataTypes.STRING },
        leverage: { type:  DataTypes.STRING },
        alm: { type:  DataTypes.STRING },
        opex: { type:  DataTypes.STRING },
        nim: { type:  DataTypes.STRING },
        opex_average: { type:  DataTypes.STRING },
        opex_nii: { type:  DataTypes.STRING },
        return_asset: { type:  DataTypes.STRING },
        return_equity: { type:  DataTypes.STRING },
        irr: { type:  DataTypes.STRING },
        avg_borrowing: { type:  DataTypes.STRING },
        spread: { type:  DataTypes.STRING },
        createdby: { type:  DataTypes.INTEGER },
        updatedby: { type:  DataTypes.INTEGER }
        
    },
    {
      sequelize,
      tableName: 'credit_financial_analysis',
      modelName: 'CreditFinancialAnalysis',
    }
  )


  return CreditFinancialAnalysis
}