I have 4 tables -- store, catalog_galleries, catalog_images, and catalog_financials.
When I traverse the relationship from store --> catalog_galleries --> catalog_images in other words: store.getCatalogGallery().getCatalogImages() I get duplicate records. Does anyone know what could be the cause of this? Any suggestions on where to look?
The store table has a OneToOne relationship with catalog_galleries which in turn has a OneToMany relationship with catalog_images and an eager fetch type. The store table also has a OneToMany relationship with catalog_financials. Note: the catalog_images table does NOT contain duplicate data; however, rows may have the same value in the gallery_id column. This column is a join column between catalog_images and catalog_galleries.
Below are the relevant entities: