'use strict'
const { Model } = require('sequelize')
module.exports = (sequelize, DataTypes) => {
  class Brokenperiods 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' })
    //}

    
  }
  Brokenperiods.init(
    {
      entity_id: { type:  DataTypes.INTEGER },
      from: { type:  DataTypes.DATE },
      to: { type:  DataTypes.DATE },
      months: { type:  DataTypes.INTEGER },
      cy: { type:  DataTypes.INTEGER },
      py: { type:  DataTypes.INTEGER },
      variation: { type:  DataTypes.STRING },          
      createdby: { type:  DataTypes.INTEGER },
      updatedby: { type:  DataTypes.INTEGER },
      
    },
    {
      sequelize,
      tableName: 'brokenperiods',
      modelName: 'Brokenperiods',
      createdAt: 'createdon',
      updatedAt: 'updatedon',
      
    }
  )
  return Brokenperiods
}