why are you using character data?
Since all the tables id starts with 1,2,3... and I have complex relationship across the tables identifying the PK-FK combination is very confusing. Instead of all tha tables primary key starts with 1,2,3.... I can have a more meaningful id.
do the incremented value have to be sequential?
Not necessarliy, but how to configure it in hibernate for id.