Data structure - Aitchy/single_surname_family_lines GitHub Wiki

The main entities of a family and their related attributes are defined as:

Family Lines:

• Family Line ID (unique)
• Confirmed
• Date Added
• Date Modified

Family Notes:

• ID (unique)
• Family Line ID (foreign key)
• Display Order
• Note
• Date Added
• Source Reference

Family Members:

• ID (unique)
• First Name
• Second Name
• Third Name
• Sex (male or female)
• Family Line ID (foreign key)
• Child Of (foreign key)
• DOB Day
• DOB Month
• DOB Year
• DOB Place
• DOB Parish
• DOC Day
• DOC Month
• DOC Year
• DOC Place
• DOC Parish
• DOD Day
• DOD Month
• DOD Year
• DOD Place
• DOD Parish
• No Children
• Never Married

Others:

• ID (unique)
• First Name
• Second Name
• Third Name
• Surname
• Sex (male or female)
• Child Of (foreign key)
• DOB Day
• DOB Month
• DOB Year
• DOB Place
• DOB Parish
• DOC Day
• DOC Month
• DOC Year
• DOC Place
• DOC Parish
• DOD Day
• DOD Month
• DOD Year
• DOD Place
• DOD Parish
• No Children
• Never Married

Parents:

• ID (unique)
• Father's First Name
• Father's Second Name
• Father's Surname Name
• Mother's First Name
• Mother's Second Name
• Mother's Surname Name
• DOM Day
• DOM Month
• DOM Year
• DOM Place
• DOM Parish
• Alternate DOM Day
• Alternate DOM Month
• Alternate DOM Year
• Alternate DOM Place
• Alternate DOM Parish
• No Children
• Never Married
• Note
• Source Reference

Spouses:

• ID (unique)
• First Name
• Second Name
• Third Name
• Surname
• Sex (male or female)
• Child Of (foreign key)
• DOB Day
• DOB Month
• DOB Year
• DOB Place
• DOB Parish
• DOC Day
• DOC Month
• DOC Year
• DOC Place
• DOC Parish
• DOD Day
• DOD Month
• DOD Year
• DOD Place
• DOD Parish

Unions:

• ID (unique)
• Family Member's ID
• Spouse's ID
• DOM Day
• DOM Month
• DOM Year
• DOM Place
• DOM Parish
• Alternate DOM Day
• Alternate DOM Month
• Alternate DOM Year
• Alternate DOM Place
• Alternate DOM Parish
• No Children
• Note