On Tuesday 28 October 2003 11:24 am, Dathan Vance Pattishall wrote: > Think of a binary tree. > > Parent_id auto increment > Child_id > > Details of the famly > > The head of the family has a child_id == parent_id > > All members of the family have different child_ids but the same > parent_id > > Then you can do some really cool recursive fast searches.
But this does NOT work well for real life genealogy. Think of step/half families, etc. No, better to look at system's that deal with this. Look at GEDCOM, genxml, or similar systems. I know I have seen several gedcom -> sql schema's out there, some for mysql even. There are also several systems for archiving information such as family events or media, and linking those people to that data. -- Jayce^
pgp00000.pgp
Description: signature