hi i am trying to make a family tree website using php mysql, i have the following tables im not sure if its correct or if i am going the right way about it, can someone help me out please. i am using phpmyadmin
i have 5 tables:
USERS:
user_id (PK)
username
password
firstname
lastname
email
FAMILY_TREE:
user_id(FK)
family tree name
description
family tree ID(PK)
FAMILY_MEMBERS:
family memberID(PK)
firstname
lastname
date of birth
date of death
place of birth
place of death
gender
family treeID(FK)
motherID(FK)
fatherID(FK)
MOTHERS:
motherID(PK)
mother of family(FK)
mothers userID(FK)
FATHERS:
fatherID(PK)
father of family(FK)
fathers userID(FK)
user table: has web users details and stores password
family tree table: holds family tree id making it unique
family member: will hold all members of the family
mothers: will hold into who is whos mother
father: will hold into who is whos father
i just wanted to know if my table structure is correct and if im going the right way about it.
can someone also help me with sql join query
this is how my tables loook like
http://img232.imageshack.us/img232/7355/relationshipkf8.jpg
