hello i'm working on a web project with the hibernate framework
i was dealing with this situation : i have multiple procedure , each procedure is a table , each procedure has it's own document types and its own documents

documents types is also a table which contains the list of document types related to a procedure , so it is static , each element from a specific procedure table has the same types of documents

but documents is another table which contains the list of documents that were scanned for an element from a specific procedure

please see this question http://stackoverflow.com/questions/17272729/conceptual-issue-working-with-hibernate
for more detail