This is how I see marriage

humans
- id
- forename
- surname
- birthdate

binary_marriages
- id
- partner_1_id (foreign key references column humans.id)
- partner_2_id (foreign key references column humans.id)
- marriage_date
- divorce_date (NULL if still married)

>>1
idiot!


struct human {
 long int     id;
 int          gender; // 0=none, 1=male, 2=female, 3=herm, 4=other
 char *       name;
 }
struct marriage {
 human *      member;
 void *       married_to_this; // set to another marriage struct if married to another human, or NULL if unmarried or already part of existing marriage
 }