'use strict'
const { Model } = require('sequelize')
module.exports = (sequelize, DataTypes) => {
  class EntityDetails extends Model {
    /**
     * Helper method for defining associations.
     * This method is not a part of Sequelize lifecycle.
     * The `models/index` file will call this method automatically.
     */
    // define association here 
    // static associate({ Financials }) {
      // this.hasMany(Financials, { foreignKey: 'entity_id', as: 'financialsData' })
    // }
    
    
  }
  EntityDetails.init(
    {
      
      loan_no_id: { type:  DataTypes.INTEGER },
      pan_no: { type:  DataTypes.STRING },
      losid: { type:  DataTypes.STRING },
      senp_sep: { type:  DataTypes.STRING },
      cat_of_sep: { type:  DataTypes.STRING },
      sub_cat_of_sep: { type:  DataTypes.STRING },
      entity_name: { type:  DataTypes.STRING },
      bureau_score: { type:  DataTypes.STRING },
      bureau_name: { type:  DataTypes.STRING },
      entity_type: { type:  DataTypes.STRING },
      entity_formation_date: { type:  DataTypes.DATE },
      entity_vintage_years: { type:  DataTypes.STRING },
      total_no_of_members: { type:  DataTypes.INTEGER },
      registered_address_of_business: { type:  DataTypes.STRING },
      registered_address_state: { type:  DataTypes.STRING },
      registered_address_city: { type:  DataTypes.STRING },
      registered_address_pin: { type:  DataTypes.INTEGER },
      registered_address_ownership_status: { type:  DataTypes.STRING },
      operating_address_of_business: { type:  DataTypes.STRING },
      operating_address_ownership_status: { type:  DataTypes.STRING },
      operating_address_city_category: { type:  DataTypes.STRING },
      operating_address_state: { type:  DataTypes.STRING },
      operating_address_city: { type:  DataTypes.STRING },
      operating_address_pin: { type:  DataTypes.INTEGER },
      operating_address_of_business_type: { type:  DataTypes.STRING },
      type_of_bussiness_activity: { type:  DataTypes.STRING },
      no_of_yr_at_opaob: { type:  DataTypes.INTEGER },
      area_in_which_at_opaob_is_located: { type:  DataTypes.STRING },
      workplace_type: { type:  DataTypes.STRING },
      others: { type:  DataTypes.STRING },
      external_rating: { type:  DataTypes.STRING },
      industry: { type:  DataTypes.STRING },
      other_industry: { type:  DataTypes.STRING },
      profile: { type:  DataTypes.STRING },
      any_changes_in_dirship_parship_in_lst_6mns: { type:  DataTypes.STRING },
      is_the_change_related_to_key_promoter: { type:  DataTypes.STRING },
      remark_on_change__in_directorship: { type:  DataTypes.STRING },
      createdby: { type:  DataTypes.INTEGER },
      updatedby: { type:  DataTypes.INTEGER },
      is_active: {type : DataTypes.INTEGER}
     
    },
    {
      sequelize,
      tableName: 'entity_details',
      modelName: 'EntityDetails',
    }
  )
  return EntityDetails
}