We can first divide the database design into three parts, Administration, Evidence and Conclusions. The Conclusions part can then further be divided into Interpretation, Results and Common for the elements common to both.
The Administration area of the database is the least developed section, only the basic minimum is currently being implemented.
- Manages global settings used by the database.
- The database version number, used to manage database updates.
- Manages contact information for various parts of the system.
- Handles per user system settings and details of the researchers that have contributed to the database.
The evidence section centres around the Reference table which is supported by the Source, Citation and Repository subsystems.
- Covers Citations, Sources and Repositories.
- Document transcriptions, descriptions and notes that make up the evidence.
The information presented in the Evidence section is broken down into its constituent parts: Sources, Dates, Places, Personas, Names, Relationships and Eventas. Personas and Eventas are used to glue all these entities back together again and are linked to the Events, Individuals and Families that are the end results of the process.
These subsystems are used by both the Interpretation and Results.
- A subsystem to handle dates, date ranges and date conversions.
- A subsystem to cover place names and locations.
- A subsystem that handles name parts and titles.
- Event Types
- Part of the Event subsystem that describes event types and the roles that are involved.
This is the area where the main work is done.
- The Persona is the representation of a person as they appear in a reference document.
- The Eventa is the representation of an event as it appears in a reference document.
The Individuals and Family relationships are the results of the interpretation of the evidence, using various tables to tie things back to the interpretation.
- The Individuals and Family links that result from the interpretation.
- The part of the Event subsystem that describe the real events we believe occurred.