'use strict'
const { Model } = require('sequelize')
module.exports = (sequelize, DataTypes) => {
  class PropertyInformation extends Model {
   
  }
  PropertyInformation.init(
    {
        pd_id: { type:  DataTypes.INTEGER },
        property_address: { type:  DataTypes.STRING },
        property_type: { type:  DataTypes.STRING },
        occupancy_status: { type:  DataTypes.STRING },
        permitted_property_usage: { type:  DataTypes.STRING },
        actual_property_usage: { type:  DataTypes.STRING },
        built_up_area: { type:  DataTypes.STRING },
        built_up_area_uom: { type:  DataTypes.STRING },
        approx_mkt_val: { type:  DataTypes.INTEGER },
        property_Ownership_Status: { type:  DataTypes.STRING },
        createdby: { type:  DataTypes.INTEGER },
        updatedby: { type:  DataTypes.INTEGER }
        
    },
    {
      sequelize,
      tableName: 'sales_property_information',
      modelName: 'PropertyInformation',
    }
  )

  return PropertyInformation
}