'use strict'
const { Model } = require('sequelize')
module.exports = (sequelize, DataTypes) => {
  class StockDetail extends Model {
   
  }
  StockDetail.init(
    {
        pd_id: { type: DataTypes.INTEGER },
        stock_info_available: { type:  DataTypes.STRING },
        stock_not_available_reason: { type:  DataTypes.STRING },
        estimated_uom: { type:  DataTypes.STRING },
        stock_type: { type:  DataTypes.STRING },
        provider_name: { type:  DataTypes.STRING },
        provider_observed: { type:  DataTypes.STRING },
        estimated_quantity: { type:  DataTypes.INTEGER },
        observed_estimated_uom: { type:  DataTypes.STRING },
        estimated_stock_value: { type:  DataTypes.INTEGER },
        company_name: { type:  DataTypes.STRING },
        common_remarks: { type:  DataTypes.STRING },
        estimated_uom_master: { type:  DataTypes.STRING },
        name_of_the_company: { type:  DataTypes.STRING }, // new
        createdby: { type:  DataTypes.INTEGER },
        updatedby: { type:  DataTypes.INTEGER },
        display_order: { type:  DataTypes.INTEGER }
        
    },
    {
      sequelize,
      tableName: 'credit_stock_details',
      modelName: 'StockDetail',
    }
  )


  return StockDetail
}