RetroGen – GEDCOM Loading

The RetroGen development is proceeding well, with work complete on individual attributes, text transcriptions for citations and sources, sources for notes and media for submitters. The list of outstanding items is reduced to the following;

• HEADER; Name of source data, publication date and copyright messaging, transmission time, submission system, language, place and note,
• INDIVIDUAL; Restrictions, sealing and submission system, associations, ancestry and descendants interests, record file number, ancestry file number, reference number, automated  record id and change date,
• FAMILY; Age of husband and wife at event, count of children, sealing and submission system, reference numbers, automated record id and change date,
• MEDIA; complete,
• NOTE; User reference number, automated record id and change date,
• REPOSITORY; User reference type, automated record id and change date,
• SOURCE; Data, concatenation on some source fields, abbreviation, user reference type, automated record id and change date,
• SUBMITTER; Language, registered number of a submitter of Ancestral file data, automated record id and change date,
• EVENT; Address, age, responsible agency and cause of event,
• CITATION; Role in event and quality assessment.

An updated entity relationship diagram is attached including text transcriptions;

******************************************************************
*     ┌────────────┐      ┌────────────┐      ┌────────────┐     *
*     │ Individual │      │   Event    │      │  Citation  │     *
*     ├────────────┤      ├────────────┤      ├────────────┤     *
*     │Id      (PK)├─┬───>┤Id+No.  (PK)├─────>┤Id+No.  (PK)│     *
*     │Name        │ ├───>┤Id+Tag  (SK)├─────>┤IdTagEv#(SK)│     *
*     │Sex         │ │    │Date        │      │Source Id   ├───┐ *
*     │Birth Date  │ │    │Place       │      │Details     │   │ *
*     │Death Date  │ │    │Details     │      │APID        │   │ *
* ┌───┤Child Family│ │    │Type        │      │Text Id     ├──┐│ *
* │┌──┤SpouseFamily│ │    │Ref Note Id ├─┐    │Ref Note Id ├┐ ││ *
* ││  │Ref Note Id ├─(───┐│InlineNoteId├─┤    │InlineRefId ├┤ ││ *
* ││  │InlineNoteId├─(───┤│Media Id    ├─(─┐  │Media Id    ├(┐││ *
* ││  │Media Id    ├─(─┐ │└────────────┘ │ │  └────────────┘││││ *
* ││  └────────────┘ │ │ └───────────────┤ │  ┌────────────┐││││ *
* ││  ┌────────────┐ │ └─────────────────(─┤  │    Note    │││││ *
* ││  │   Family   │ │    ┌────────────┐ │ │  ├────────────┤││││ *
* ││  ├────────────┤ │    │    Text    │ ├─(─>┤Id+No.  (PK)│││││ *
* ││  │Id      (PK)├─┘    ├────────────┤ │ │  │Data        │││││ *
* │├─>┤Husband Id  │   ┌─>┤Id+No.  (PK)│ │ │  │Source Id   ├(((┤ *
* │└─>┤Wife Id     │   │  │Data        │ │ │  └────────────┘││││ *
* └──>┤Child Id    │   │  └────────────┘ │ │  ┌────────────┐││││ *
*     │Ref Note Id ├───(─────────────────┤ │  │   Media    │││││ *
*     │InlineNoteId├───(─────────────────┤ │  ├────────────┤││││ *
*     │Media Id    ├───(─────────────────(─├─>┤Id+No.  (PK)│││││ *
*     └────────────┘   │                 │ │  │File        │││││ *
*     ┌────────────┐   │                 │ │  │Form        │││││ *
*     │   Source   │   │                 │ │  │Title       │││││ *
*     ├────────────┤   │  ┌────────────┐ │ │  │Ref Note Id ├(┤││ *
*  ┌─>┤Id      (PK)│   │  │ Repository │ │ │  │InlineNoteId├(┤││ *
*  │  │Author      │   │  ├────────────┤ │ │  └────────────┘││││ *
*  │  │Repo Id     ├───(─>┤Id      (PK)│ │ │  ┌────────────┐││││ *
*  │  │Publisher   │   │  │Name        │ │ │  │ Submitter  │││││ *
*  │  │ReferenceNo.│   │  │Address     │ │ │  ├────────────┤││││ *
*  │  │APID        │   │  │Ref Note Id ├─┤ │  │Id      (PK)│││││ *
*  │  │Repo Name   │   │  │InlineNoteId├─┤ │  │Name        │││││ *
*  │  │Call Number │   │  └────────────┘ │ │  │Address     │││││ *
*  │  │Text Id     ├───┤                 │ │  │Media Id    ├((┤│ *
*  │  │Ref Note Id ├───(─────────────────┤ │  └────────────┘││││ *
*  │  │InlineNoteId├───(─────────────────┴─(────────────────┘│││ *
*  │  │Media Id    ├───(───────────────────┴─────────────────┘││ *
*  │  └────────────┘   └──────────────────────────────────────┘│ *
*  └───────────────────────────────────────────────────────────┘ *
******************************************************************