hvac scraper uses foreignkeys now