Paul Sturrock, thanks for the reply.
generate my mappings/pojos from it then edit them by hand till they fit.
Wish to clarify. You mean this sequence ? :
1stly, hand code/hand design DDL SQL - tables/foreign key reference integrity and all
2ndly, generate hbm.xml mapping files and Java pojos from number 1.
3rdly, make manual adjustments to any of the 3 above (DB, hbm,xml and java pojos) where necessary.
Is this the way ...how you would normally do things ?
For step 2, what tool(s) do you use for the generation work ?
Thanks.