Thanks for quick response.
But My scenario is different
Master table of User , Division and Sub-Division
User table
id name
1 x
2 y
3 z
Division table
id name
1 x
2 y
3 z
Sub-Division table
id name
1 a
2 b
3 c
Division To Sub-Division
id division_id sub_division_id
1 1 1
2 1 2
so on…
Finally when i create a user then assign particular division and sub-division.
Using following table
id user_id division_id sub_division_id
1 1 1 1
2 1 1 2
3 2 1 1
Drawback above table is linked in hibernate it will display all subdivision for every division. association only based on division id. but i need to associate with both user_id and division_id.
Above structure relationship is possible in hibernate for CRUD operation.