code_junkie

How can I represent a many to many relationship to the same table/entity in hibernate?

Nov 12th, 2011
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.94 KB | None | 0 0
  1. CREATE TABLE Table1 (pkcol1 ... PRIMARY KEY, ...);
  2. CREATE TABLE Table2 (pkcol2 ... PRIMARY KEY, ...);
  3. CREATE TABLE MtoM_Table1_Table2
  4. (
  5. pkcol1 ... REFERENCES Table1,
  6. pkcol2 ... REFERENCES Table2,
  7. PRIMARY KEY (pkcol1, pkcol2)
  8. );
  9. -- CREATE INDEX fk1_mtom_table1_table2 ON MtoM_Table1_Table2(pkcol1);
  10. -- CREATE INDEX fk2_mtom_table1_table2 ON MtoM_Table1_Table2(pkcol2);
  11.  
  12. CREATE TABLE Table1 (pkcol1 ... PRIMARY KEY, ...);
  13. CREATE TABLE MtoM_Table1_Table1
  14. (
  15. pkcol1 ... REFERENCES Table1(pkcol1),
  16. akcol1 ... REFERENCES Table1(pkcol1),
  17. PRIMARY KEY (pkcol1, akcol1)
  18. );
  19. -- CREATE INDEX fk1_mtom_table1_table1 ON MtoM_Table1_Table1(pkcol1);
  20. -- CREATE INDEX fk2_mtom_table1_table1 ON MtoM_Table1_Table1(akcol1);
  21.  
  22. CREATE TABLE Table1
  23. (
  24. pkcol1 ... /* PRIMARY KEY */,
  25. fkcol1 ... /* FOREIGN KEY REFERENCES Table1(pkcol1) */,
  26. ...
  27. );
  28. -- CREATE INDEX fk1_table1 ON Table1(pkcol1);
  29. -- CREATE INDEX fk2_table1 ON Table1(fkcol1);
Add Comment
Please, Sign In to add comment