code_junkie

One To Many To Itself

Nov 11th, 2011
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. ID INT NOT NULL PRIMARY KEY
  2. SIRE_ID INT
  3. DAME_ID INT
  4.  
  5. ID INT NOT NULL PRIMARY KEY
  6. SIRE_ID INT REFERENCES TABLENAME (ID)
  7. DAME_ID INT REFERENCES TABLENAME (ID)
  8.  
  9. [ID],[Sire_ID],[Dame_ID];
  10. 0,null,null (male)
  11. 1,null,null (female)
  12. 2,null,null (female)
  13. 3,0,1 (male)
  14. 4,0,2 (male)
  15. 5,null,null (female)
  16. 6,3,5
  17. 7,4,5
  18.  
  19. While (myAnimal.HasChildren) {
  20. Animal[] children = GetChildren(Animal.ID)
  21. for (int x=0; x<children.length; x++)
  22. myAnimal.Children.Add(children[x]);
  23. }
  24.  
  25. ID Primary Key,
  26. Parent_ID Foreing_Key
  27. ( data )
Add Comment
Please, Sign In to add comment