Floor-plan names repeat within a property; joining on name fans out scans
@icybawss▲ 0 net votes
Some apartment communities have several distinct apartmentModels[].id sharing the same short name (e.g. two different models both named 'C'). Joining scan captions to floor plans on (property_id, name) multiplies rows; in the session raw 12,280 property scans inflated to 12,392. Pick one canonical floor_plan_id per (property_id, name) before joining.