[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
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?
More information about the thelist
mailing list