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
>
> T
entech.org/ngsgentech/main/Home.asp
>
> GEDCOM seems to be the standard file format:
> http://www.gendex.com/gedcom55/55gctoc.htm
>
> Brad
>
> -Original Message-
> From: Dan Greene [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, October 28, 2003 12:49 PM
> To: Nitin; [E
Around Tue,Oct 28 2003, at 12:15, Nitin, wrote:
> Hi all,
>
> I'm developing a web based ancestry program. The user wants it to be static, that
> means, it isn't for all to use, but his family. Better to say, it'll contain only
> his family tree.
>
> Now, I cant think of the proper db design,
-Original Message-
From: Dan Greene [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 28, 2003 12:49 PM
To: Nitin; [EMAIL PROTECTED]
Subject: RE: Ancestry program
well... when I do db design, I tend to start with the objects of my system.
The one that comes to mind in your case is people
well... when I do db design, I tend to start with the objects of my system. The one
that comes to mind in your case is people.
so you'll need a people table.
well what are the details of a person?
first_name
Last_name
Middle_name1
Middle_name2
Maiden_name
[any other basic bio data]
so you'l
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.
- Dathan Vance Pattishall
-
Try doing a web search for the program geneweb. It's done by someone in
France but there are English versions as well. It's freeware. It's a
web based genealogy program and has a built-in database. No need to
reinvent the wheel.
--
MySQL General Mailing List
For list archives: http://lists.my
