samra Posted August 13, 2015 Share Posted August 13, 2015 I want to create a family tree site in php. That site should be able to display the parent and child nodes along with their spouse. I also need to display relation between the member of any nodes level to any other person on the basis of their common ancestor in the tree. Now am totally at loss regarding the db schmea. so far i have created a table named family_tree which include the following fields: family_id name spouse_name parent_level (e.g 1,2,2 so on nodes levels) children it all seems quite vague sort of thing to me. dont know where exactly should be proceeding. how many tables i will be needing? how these tables should be related? please reply. thanks Quote Link to comment Share on other sites More sharing options...
Barand Posted August 13, 2015 Share Posted August 13, 2015 perhaps +---------------+ | family_tree | +---------------+ | family_id | | firstname | | surname | | gender | | spouse_id | | mother_id | | father_id | +---------------+ Quote Link to comment Share on other sites More sharing options...
samra Posted August 13, 2015 Author Share Posted August 13, 2015 thanks for your reply. searching for the common ancestor can work out too with this single table? am just a newbie in php, just know CRUD so far. Quote Link to comment Share on other sites More sharing options...
Barand Posted August 13, 2015 Share Posted August 13, 2015 Search following the id links for matching ids Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.