'use strict'
const { Model } = require('sequelize')
module.exports = (sequelize, DataTypes) => {
  class CreditFinancialInformation extends Model {
   
  }
  CreditFinancialInformation.init(
    {
        pd_id: { type: DataTypes.INTEGER },
        financial_info_available: { type:  DataTypes.STRING },
        net_profit_rs: { type:  DataTypes.INTEGER },
        net_profit_to_sales_percent: { type:  DataTypes.STRING },
        sales_amount: { type:  DataTypes.STRING },
        is_any_other_working_captial_facility: { type:  DataTypes.STRING },
        facility_details_specify: { type:  DataTypes.STRING },
        facility_details_other_lender: { type:  DataTypes.STRING },
        facility_details_other: { type:  DataTypes.STRING },
        broken_period_turnover_percent: { type:  DataTypes.STRING },
        broken_period_turnover_py: { type:  DataTypes.STRING },
        broken_period_turnover_cy: { type:  DataTypes.STRING },
        broken_period_no_of_months: { type:  DataTypes.STRING },
        broken_period_to_month: { type:  DataTypes.STRING },
        broken_period_from_month: { type:  DataTypes.STRING },
        inventory_days_cm: { type:  DataTypes.INTEGER },
        creditor_days_cm: { type:  DataTypes.INTEGER },
        debtor_days_cm: { type:  DataTypes.INTEGER },
        fy: { type:  DataTypes.STRING },
        sales_revenue: { type:  DataTypes.STRING },
        net_profit: { type:  DataTypes.STRING },
        net_profit_sales_percent: { type:  DataTypes.STRING },
        sales_py: { type:  DataTypes.STRING },
        netprofit_py: { type:  DataTypes.STRING },
        netprofit_py_percent: { type:  DataTypes.STRING },
        debtor_days_cet: { type:  DataTypes.STRING },
        creditor_days_cet: { type:  DataTypes.STRING },
        inventory_days_cet: { type:  DataTypes.STRING },
        company_name: { type:  DataTypes.STRING },
        no_of_financial_years: { type:  DataTypes.INTEGER },
        common_remarks: { type:  DataTypes.STRING },
        createdby: { type:  DataTypes.INTEGER },
        updatedby: { type:  DataTypes.INTEGER },
        display_order: { type:  DataTypes.INTEGER }
        
    },
    {
      sequelize,
      tableName: 'credit_financial_information',
      modelName: 'CreditFinancialInformation',
    }
  )


  return CreditFinancialInformation
}