'use strict'
const { Model } = require('sequelize')
module.exports = (sequelize, DataTypes) => {
  class Itemsmaster 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({ Model_name }) {
      //this.hasMany(Model_name, { foreignKey: 'child_table_prim_key', as: 'child_tbl_name' })
    //}
    static associate({ Statementsmaster }) {
      this.belongsTo(Statementsmaster, { foreignKey: 'id', as: 'statementsmasterData' })
    }
    static associate({ Subsectionsmaster }) {
      this.hasMany(Subsectionsmaster, { foreignKey: 'section', as: 'subsectionsmasterData' })
    }
    static associate({ Sectionsmaster }) {
      this.hasMany(Sectionsmaster, { foreignKey: 'statement', as: 'sectionsmasterData' })
    }

    
  }
  Itemsmaster.init(
    {  
      statement: { type:  DataTypes.INTEGER },
      section: { type:  DataTypes.INTEGER },
      subsection: { type:  DataTypes.INTEGER },
      itemtext: { type:  DataTypes.STRING },
      itemorder: { type:  DataTypes.INTEGER },
      itemkey: { type:  DataTypes.STRING },
      pvtltditemkey: { type:  DataTypes.STRING },
      pvtltd_itemorder:  { type:  DataTypes.INTEGER }, 
      manual:  { type:  DataTypes.INTEGER }, 
      pvtltd:   { type:  DataTypes.INTEGER }, 
      llp:   { type:  DataTypes.INTEGER },     
      others:  { type:  DataTypes.INTEGER }, 
      formula:  { type:  DataTypes.STRING }, 
      is_calculated:  { type:  DataTypes.INTEGER }, 
      is_summary:  { type:  DataTypes.INTEGER }, 
      is_active:  { type:  DataTypes.INTEGER }, 
      createdby: { type:  DataTypes.INTEGER },
      updatedby: { type:  DataTypes.INTEGER },
      
    },
    {
      sequelize,
      tableName: 'itemsmaster',
      modelName: 'Itemsmaster',
      createdAt: 'createdon',
      updatedAt: 'updatedon',
    }
  )
  return Itemsmaster
}