G5 Person

create table person (
    id              serial primary key,
    slug            varchar(255) unique not null,
    ids_in_sources  jsonb not null,
    partial_ids     jsonb not null,
    name            jsonb not null,
    sex             char(1),
    birth           jsonb not null,
    death           jsonb not null,
    occus           jsonb not null,
    trust           char(1),
    acts            jsonb not null,
    history         jsonb not null,
    notes           jsonb not null
);

Person ids

Unique ids

• Person slug, its g5 unique id (see definition in page G5 database) - a string like abonneau-pierre-1854-01-10.
  These can be read by humans and are used to build the public URL of a person in opengauquelin.org.
• Id generated by the database (serial in postgresql, equivalent of autoincrement in mysql).
  These are used by postgresql (the database management system) to link persons to other entities, like groups.

Ids in sources

select ids_in_sources from person where slug='dumas-georges-1866-03-06';

{
    "a2": "241",
    "a6": "282",
    "afd5": "325"
}

Partial ids

select ids_partial from person where slug='dumas-georges-1866-03-06';

{
    "lerrcp": "A2-241",
    "muller": "M5-325"
}

Build history

Build notes

["CHECK: birth day - A6-868 1906-09-11 / M1writers 158 1903-09-11"]
["Death informations come from https://earlyaviators.com/eborn1.htm"]
["Value published in LERRCP corrected in APP"]

Person name

name:
  full:             # string
  family:           # string
  given:            # string
  official:
    family:         # string
    given:          # string
  spouse: []        # array of strings
  alter: []         # array of strings

• name.full, name.given, name.family represent the name commonly used to designate a person.
  These can be different from the official name.
  It can be either the "real" name of the person, or a pseudonym.
  Rules:
  • All persons in the database either have name.given and name.family filled, or name.full filled.
  • If name.full is filled, then both name.given and name.family are empty.
  • name.given and name.family are either both filled or both empty.
  • The rule to build the name of a person is : if name.full is not empty, it is used. Else the concatenation of name.given and name.family is used.
  • For noble persons, the nobiliary particle is contained in name.family.
• name.official represent the exact spelling of the name, as written in the birth certificate.
  An important rule is: these fields are filled only if they differ from the common fields.
  If the person has several given names, name.official.given contains them all.
• name.spouse : array of spouse names (in general, used for married women). This field is informative only ; if the person is known using her spouse name, this information must be repeated in field name.family.
• name.alter: Array of alternative names.

Examples

• Most current case

  name:
    given: Elie
    family: Cartan
    official:         
      given: Elie Joseph
  

  This person is known as "Elie Cartan".
  The official family name is the same as the common family name, so the information is not repeated. in the official.name field.
  The birth certificate contains several given names. As they differ from the common given name, the field official.given is filled.
• name.family differ from name.official.family

  name:
    family: Calvé
    given: Emma
    official:
      family: Calvet
      given: Rosa Noémie Emma
  

  This person is known as "Emma Calve".
  Here, both given and family names are different from the birth certificate, so both are filled.
• Usage of name.full

  name:
    full: Fernandel
    official:
      family: Constantin
      given: Fernand Joseph Désiré
  

  This person is known as "Fernandel".
  The fields name.full is used, but the fields name.family and name.given are not used.
• Usage of name.alter

  name:
    family: Vian
    given: Boris
    official:
      given: Boris Paul
    alter:
      - Vernon Sullivan
      - Bison Ravi
      - Brisavion
  

  This person is known as "Boris Vian", and he published books using various pseudonyms, stored in field alter.
• Usage of name.spouse

  name:
    family: Choquet-Bruhat
    given: Yvonne
    official:
      family: Bruhat
      given: Yvonne, Suzanne, Marie-Louise
    spouse:
      - Fourès
      - Choquet
  

  This person is known as "Yvonne Choquet-Bruhat".
  She was married twice, which is indicated in the field name.spouse.

Birth and death dates

{
    "date": "1891-07-18 08:00",
    "date-ut": "1891-07-18 07:51",
    "tzo": "+00:09:21",
    "notime": null,
    "lmt": null,
    "place": {
        "c1": null,
        "c2": "33",
        "c3": "",
        "cy": "FR",
        "lg": -0.5805,
        "lat": 44.84044,
        "name": "Bordeaux",
        "geoid": 3031582
    }
}

{
    "tzo": {
        "err": "IT1 End of WW2",
        "trust": 0
    }
}

{
    "tzo": {
        "err": "IT1 End of WW2",
        "trust": 0
    }
}

Links with other entities