CREATE INDEX IF NOT EXISTS "ix_epc_building_part_epc_property" ON "epc_building_part" USING btree ("epc_property_id");--> statement-breakpoint
CREATE INDEX IF NOT EXISTS "ix_epc_energy_element_epc_property" ON "epc_energy_element" USING btree ("epc_property_id");--> statement-breakpoint
CREATE INDEX IF NOT EXISTS "ix_epc_floor_dimension_building_part" ON "epc_floor_dimension" USING btree ("epc_building_part_id");--> statement-breakpoint
CREATE INDEX IF NOT EXISTS "ix_property_portfolio" ON "property" USING btree ("portfolio_id");
