Briefly, it is composed of several many-to-many polymorphic relationships as described:
resourcescan have many
sourcesand the pivot table
lot_numberinformation to make each row in the pivot table unique. Many resources could also come from the same source or from different sources, differentiated by the catalog number and lot number on the pivot table.
resourcescan also have many
publicationsattached to it, through the
noteson the pivot table
a resource’s source could also be described in many publications.
- Since the resource’s source is differentiated by the pivot table
sourceableshow should I save the relationship between the pivot rows of
- How to retrieve a resource with all it’s publications and also with the sources with all corresponding publications?