Working on law firm website. Different Lawyers have assigned different cases ( in same law firm).
For that purpose it needs Family Tree implementation to collect clients history.
There is main table
personID primary key AUTO INCREMENT firstName lastName sex birthDate birthPlace deathDate deathPlace
parents, spouse, childre all are stored in same
'persons' table as person. Everyone is treated as independent person. some clients are married twice, some are not married, some are divorced. So need help to maintain records of Marriages.
I need help to create tables to record information regarding parents, spouse info (husband or wife) , children, Married or Remarried, previous spouse , or Divorced(Marriage Date, Divorce Date).
How to collect info of relationship like uncle, aunt, sister, brother, cousin, in-laws (brother-in-law , sister-in-law etc.),-
( I'm just thinking of this, 1. table relation person1_id person2_id relationship_type (mother,father,sister,aunt,uncle,in-laws) 2. table partner person1_id person2_id relationship_type (husband or wife or live-in relationship) beginDate endDate Is this okay??? )
#Need Help To Design Database#