We used middlegen for this purpose but seriously be careful about the HBMs and the classes it generates it should be reviewed by an expert and compared to the object model. Excuse me for being so talkative but the point is that you should have your object model before designing database  (Object Relational Mapping tool).