[thelist] Genealogy database schema

[Lonnie.Kraemer]

> Seems like the following should do the trick for a simple table
structure:
>
> column name |   data type
> ------------+----------------------------------------------
> id          |   integer
> first_name  |   text
> last_name   |   text
> dob         |   date
> dod         |   date
> mother      |   integer (relation to other row, this table)
> father      |   integer (relation to other row, this table)

Yup, I can do this, but then what? How do I query this into a logical
tree format? How do I make additions that may not necessarily be in
chronological order, especially if dob and/or dod are not available?