To understand the mysteries of life you must look around and within. You will see patterns everywhere; patterns that seem to manifest themselves over and over again. These patterns exist intertwined within nature and man bridging the gap between the enigma of self and universe. You see them in spiraling galaxies and the Mandelbrot fractal of fossilized Ammonoidea; growing from the unknown to atoms to molecules to solar systems to galaxies to the paradoxical expanses of the universe with origins and destinations unknown; just like us in birth and death. The similarities of tree branches, rivers and blood veins. The power of cellular division and nuclear fission, the patterns of finger prints like endoplasmic reticulum, or a black opal's play of fire like the nebula of supernova. Moon shots are like protoplasmic lurches, while simple thoughts and observations of the nature around us take us beyond the unknown. The clues to the great mystery are all around us and deep within us.
Bryant H McGill
Whilst the starting point for this database was the GenTech Genealogical Data Model, significant changes have been made and with more to come, the TFP database should be treated in its own right as a separate design.
The current status of the database can best be described as experimental. Most of the entities in the diagram have been implemented in a test program, but some areas - such as data confidence (or Surety) are missing. Other areas, like the Places subsystem are in need of a major change. Whilst yet others like the Citation/Source entities are carried over wholesale from the GDM and have yet to be fully tested.
The database is divided into three broad areas, Administration, Evidence and Conclusions. The administration area is the lest developed, but will be the area where overall genealogy project using the database is organised. The evidence section is where all the factual data is held and is probably the area that is most experimental. The conclusions area is where the collected facts are organised and turned into genealogy trees and is further divided into Interpretation and Results with a Common area supporting them.
The data is held in a relational database using the SQL standard. Currently SQLite3 is used but other SQL systems may be used in the future.
In describing the database TFP uses the following conventions. SQL keywords are written in UPPER CASE, table names in CamelCase and column names in lower_case with underscores as necessary. Table names are generally written in full whilst column names are often abbreviated.
All tables will include an explicit unique id key field, even when the field is not strictly needed. All user created records have a positive id's greater than zero. Zero id's are reserved, their meaning depending on the context. Negative id's are used for common data copied from the common database.
First class objects are associated with a short alpha code - such as 'E' for Event and 'Ea' for Eventa. These codes may be combined the records id key and used as a unique identifier for that record. These codes, together with the closely linked display page codes, are listed on the "Record Prefix" page.