'use strict'
const { Model } = require('sequelize')
module.exports = (sequelize, DataTypes) => {
  class SupplierDetail extends Model {
   
  }
  SupplierDetail.init(
    {
        pd_id: { type: DataTypes.INTEGER },
        supplier_info_available: { type:  DataTypes.STRING },
        supplier_not_available_reason: { type:  DataTypes.STRING },
        provider_name: { type:  DataTypes.STRING },
        supplier_name: { type:  DataTypes.STRING },
        contact_person_name: { type:  DataTypes.STRING },
        contact_person_designation: { type:  DataTypes.INTEGER },
        contact_person_mobile_no: { type:  DataTypes.STRING },
        person_stdcode: { type:  DataTypes.INTEGER },
        person_landline: { type:  DataTypes.INTEGER },
        type_of_payment : { type:  DataTypes.STRING },   // new
        payment_mode: { type:  DataTypes.STRING },
        credit_period_no: { type:  DataTypes.INTEGER },
        credit_total_purchase: { type:  DataTypes.INTEGER },
        company_name: { type:  DataTypes.INTEGER },
        name_of_the_company: { type:  DataTypes.STRING }, // new
        common_remarks: { type:  DataTypes.STRING },
        createdby: { type:  DataTypes.INTEGER },
        updatedby: { type:  DataTypes.INTEGER }
        
    },
    {
      sequelize,
      tableName: 'credit_supplier_details',
      modelName: 'SupplierDetail',
    }
  )


  return SupplierDetail
}