im really in trouble here so can someone please help me map this.. ive tryed so many different things but it wont work...
im a student but i can probably transfer som paypal $ if thats what it takes.

What i need is:

user 1..1 bookshelf

bookshelf 1..* bookline

bookline *..1 book


a user have a bookshelf
the bookshelf contains booklines
the booklines holds information about if the book is avalible and what book it is

a user should be able to delete a book from the bookshelf without deleting it from the real book table.

if a user is deleted the bookshelf should be deleted along with the booklines but only delete the book from the table if its the last user who have
a reference to it.

It should be possible to find the users who have a specific book.

Does this make sense or should it be done in some other way?


Hibernate version: latest

Mapping documents: tryed making some but they probably wont help

Code between sessionFactory.openSession() and session.close(): using spring

Name and version of the database you are using: mysql