[thelist] Genealogy database schema

Lonnie.Kraemer lwkraemer at directvinternet.com
Thu Jan 2 18:03:01 CST 2003

> Seems like the following should do the trick for a simple table
> 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?

More information about the thelist mailing list