Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ID INT NOT NULL PRIMARY KEY
- SIRE_ID INT
- DAME_ID INT
- ID INT NOT NULL PRIMARY KEY
- SIRE_ID INT REFERENCES TABLENAME (ID)
- DAME_ID INT REFERENCES TABLENAME (ID)
- [ID],[Sire_ID],[Dame_ID];
- 0,null,null (male)
- 1,null,null (female)
- 2,null,null (female)
- 3,0,1 (male)
- 4,0,2 (male)
- 5,null,null (female)
- 6,3,5
- 7,4,5
- While (myAnimal.HasChildren) {
- Animal[] children = GetChildren(Animal.ID)
- for (int x=0; x<children.length; x++)
- myAnimal.Children.Add(children[x]);
- }
- ID Primary Key,
- Parent_ID Foreing_Key
- ( data )
Add Comment
Please, Sign In to add comment