'use strict'
const { Model } = require('sequelize')
module.exports = (sequelize, DataTypes) => {
  class FinancialInformation extends Model {
   
  }
  FinancialInformation.init(
    {
        pd_id: { type:  DataTypes.INTEGER },
        fy: { type:  DataTypes.STRING },
        sales_revenue: { type:  DataTypes.INTEGER },
        net_profit: { type:  DataTypes.INTEGER },
        income_considered: { type:  DataTypes.INTEGER },
        income_assessment_program_recommended: { type:  DataTypes.STRING },
        fixed_obligations: { type:  DataTypes.INTEGER },
        equipment_contribution_turnover: { type:  DataTypes.STRING },
        net_profit_net_loss_to_sales : { type:  DataTypes.INTEGER },
        income_considered_per_month : { type:  DataTypes.INTEGER },
        sales_over_py : { type:  DataTypes.STRING },
        net_profit_over_py : { type:  DataTypes.STRING },
        net_profit_percentage_over_py : { type:  DataTypes.STRING },

        createdby: { type:  DataTypes.INTEGER },
        updatedby: { type:  DataTypes.INTEGER }
        
    },
    {
      sequelize,
      tableName: 'sales_financial_information',
      modelName: 'FinancialInformation',
    }
  )

  return FinancialInformation
}