I have this slightly simplified table layout:
Code:
Store ---- sid,pid ---- Pictures
| /
sid,aid aid,sid,pid
| /
Album
The weird mapping is to express that Albums only contain Pictures that are in the same Store as the current Album.
How do I write my hibernate-mapping for the Album class such that it has easy access to a collection of Pictures in that Album?
Much thanks in advance for any tips. This is my first use of Hibernate which has been great and easy to work with until I've tried to express this relationship.