The goal is to transform data into information, and information into insight.
Carly Fiorina
| Table Name field name |
Type | Description | |
|---|---|---|---|
| Top | |||
| Associate | |||
| id | Integer PK | Unique key identifying an Associated Database. | |
| path | Text | The file path (relative to current database) to associated database. | |
| comment | Text | Short comment to help identify the database in a list. | |
| Top | |||
| Citation | |||
| id | Integer PK | Unique key identifying a Citation. | |
| higher_id | Integer FK | Key identifying a higher Citation record that this one refines. Zero if there is no higher Citation. | |
| ref_id | Integer FK | Pointer to the Reference record that this is a Citation of. | |
| ref_seq | Integer | The position in the sequence of Citations for the given Reference record. | |
| rep_id | Integer FK | Pointer to the Repository record that contains this Citation. | |
| comment | Text | A comment to help clarify this Citation. | |
| uid | Text | A universal identifier to identify this record across databases. | |
| changed | Integer | The date this record was last changed, held as a JDN. | |
| Top | |||
| CitationPart | |||
| id | Integer PK | Unique key identifying a Citation Part. | |
| cit_id | Integer FK | The Citation key that this is a part of. | |
| type_id | Integer FK | The key in CitationPartType that identifies the type of CitationPart that this is. | |
| val | Text | The actual value of this citation part | |
| cit_seq | Integer | The position in the sequence of CitationParts for the given Citation record. | |
| comment | Text | A comment to help clarify this CitationPart. | |
| Top | |||
| CitationPartType | |||
| id | Integer PK | Unique key identifying a Citation Part Type | |
| name | Text | The actual name of the citation part. | |
| style | Integer | A value indicating how the value should displayed. | |
| comment | Text | A comment to help clarify this CitationPartType. | |
| uid | Text | A universal identifier to identify this record across databases. | |
| changed | Integer | The date this record was last changed, held as a JDN. | |
| Top | |||
| Contact | |||
| id | Integer PK | Unique key identifying an Contact. | |
| type_id | Integer FK | Pointer to a ContactType for this contact. | |
| list_id | Integer FK | Pointer to an ContactList record that this formas a part of | |
| list_seq | Integer | The position in the sequence of Contacts for the given ContactList record. | |
| val | Text | The Contact details, Address, Telephone number, email address etc. | |
| Top | |||
| ContactList | |||
| id | Integer PK | Unique key identifying an ContactList | |
| ind_id | Integer FK | Optional pointer to an Individual record that this is a list of contacts for. | |
| Top | |||
| ContactType | |||
| id | Integer PK | Unique key identifying an ContactType | |
| name | Text | Name of the Contact Type. ie Address, Telephone, Email, etc. | |
| uid | Text | A universal identifier to identify this record across databases. | |
| changed | Integer | The date this record was last changed, held as a JDN. | |
| Top | |||
| Date | |||
| id | Integer PK | Unique key identifying a Date. | |
| jdn | Integer | The start date of a range, stored as a Julian day number. | |
| range | Integer | The inclusive number of days in the date range. A value of 0 indicates a range of 1 day | |
| rel_id | Integer FK | If the date is based on a relative date, this points to the RelativeDate record. | |
| type | Integer |
A collection of flags indicating the type of dates held: 1=About, 2=Before, 4=After. |
|
| descrip | Text | A text representation of the date in addition or in place of the date number | |
| record_sch | Integer | A number indicating the date scheme used to record the date, Unstated, Unknown, Unlisted, Gregorian, Julian, English, Scottish etc |
|
| display_sch | Integer | A number indicating the default date scheme used for the date display, Unstated, Unknown, Unlisted, Gregorian, Julian, English, Scottish etc |
|
| uid | Text | A universal identifier to identify this record across databases. | |
| changed | Integer | The date this record was last changed, held as a JDN. | |
| Top | |||
| Event | |||
| id | Integer PK | Unique key identifying an Event | |
| title | Text | The name of the Event, such as "Marriage of John Smith and Mary Jones". | |
| higher_id | Integer FK | Unique identifier that indicates a higher Event which contains this event. | |
| type_id | Integer FK | Unique identifier that indicates to which Event Type this event belongs. | |
| date1_id | Integer FK | The point date associated with the Event. | |
| date2_id | Integer FK | The optional second date if a date range is associated with the Event. | |
| place_id | Integer FK | Unique identifier in Place that indicates where this Event took place. | |
| note | Text | Optional note that relates to the Event. | |
| date_pt | Integer | A single day used to order lists of events. | |
| user_ref | Text | Optional user defined reference code. | |
| Top | |||
| Eventa | |||
| id | Integer PK | Unique key identifying an Eventa | |
| title | Text | The name of the Event, such as "Marriage of John Smith and Mary Jones". | |
| ref_id | Integer FK | The Reference Document that was the source of the Eventa. | |
| type_id | Integer FK | Unique identifier that indicates to which Event Type this eventa belongs. | |
| date1_id | Integer FK | The point date associated with the Eventa. | |
| date2_id | Integer FK | The optional second date if a date range is associated with the Eventa. | |
| place_id | Integer FK | Unique identifier in Place that indicates where this Eventa took place. | |
| note | Text | Optional note that relates to the Eventa. | |
| date_pt | Integer | A single day used to order lists of events. | |
| uid | Text | A universal identifier to identify this record across databases. | |
| changed | Integer | The date this record was last changed, held as a JDN. | |
| Top | |||
| EventaPersona | |||
| id | Integer PK | Unique key identifying an EventaPersona. | |
| eventa_id | Integer FK | Pointer to an Eventa | |
| per_id | Integer FK | Pointer to a Persona | |
| role_id | Integer FK | Points to the role played by the Persona | |
| note | Text | Optional note that relates to the Persona | |
| per_seq | Integer | The sequence of personas included in a given eventa record. | |
| Top | |||
| EventEventa | |||
| id | Integer PK | Unique key identifying an EventEventa. | |
| event_id | Integer FK | Pointer to an Event | |
| eventa_id | Integer FK | Pointer to an Eventa | |
| conf | Float | A value, less than one, to indicate the confidence that the link is correct | |
| note | Text | Optional note that relates to the link between the events | |
| Top | |||
| EventType | |||
| id | Integer PK | Unique key identifying a Event Type | |
| grp | Integer | Holds 0=Unstated, 1=Birth, 2=Nr Birth (Baptism), 3=Marriage, 4=Family, 5=Death, 6=Nr Death (Burial), 7=Other | |
| name | Text | The name of this event type. An example might be Marriage or Burial, or Battle. | |
| uid | Text | A universal identifier to identify this record across databases. | |
| changed | Integer | The date this record was last changed, held as a JDN. | |
| Top | |||
| EventTypeRole | |||
| id | Integer PK | Unique key identifying a Event Type Role | |
| type_id | Integer FK | Unique key that identifies the Event Type to which these members belong. | |
| prime | Integer | Flag, 1=Primary role, ie the new born for birth or bride and groom in wedding. | |
| official | Integer | Flag, 1=Official role, ie Registrar for certificate or clergy for church service. | |
| name | Text | The value that distinguishes the different members of the event type, such as role (bride, groom, witness). | |
| uid | Text | A universal identifier to identify this record across databases. | |
| changed | Integer | The date this record was last changed, held as a JDN. | |
| Top | |||
| Family | |||
| id | Integer PK | Unique key identifying a Family | |
| husd_id | Integer | Pointer to the Individual who is the male partner or displayed on the left. | |
| wife_id | Integer | Pointer to the Individual who is the female partner or displayed on the right. | |
| Top | |||
| FamilyEvent | |||
| id | Integer PK | Unique key identifying a FamilyEvent | |
| fam_id | Integer FK | Pointer to a Family associated with the Event | |
| event_id | Integer FK | Pointer to the Event associated with a Family | |
| note | Text | Optional note that relates to the Family - Event link | |
| fam_seq | Integer | Sequence of the Event within the Family | |
| Top | |||
| FamilyEventa | |||
| id | Integer PK | Unique key identifying a FamilyEventa | |
| fam_id | Integer FK | Pointer to a Family associated with the Eventa | |
| eventa_id | Integer FK | Pointer to the Eventa associated with a Family | |
| conf | Float | A value, less than one, to indicate the confidence that the link is correct | |
| note | Text | Optional note that relates to the Family - Eventa link | |
| Top | |||
| FamilyIndEventa | |||
| id | Integer PK | Unique key identifying a FamilyIndEventa | |
| fam_ind_id | Integer FK | Pointer to a Family Individual relationship associated with the Eventa | |
| eventa_id | Integer FK | Pointer to the Eventa associated with a Family Individual link | |
| conf | Float | A value, less than one, to indicate the confidence that the link is correct | |
| note | Text | Optional note that relates to the Family Individual - Eventa link | |
| Top | |||
| FamilyIndividual | |||
| id | Integer PK | Unique key identifying a FamilyIndividual | |
| fam_id | Integer FK | Pointer to the Family that the Individual is a child of. | |
| ind_id | Integer FK | Pointer to the Individual | |
| seq_child | Integer | Sequence of the child Individuals in the Family, normally in age order | |
| seq_parent | Integer | Where an individual is the child of more than one family, (ie genetic child and adopted child) this value will sequence the order of the the families. | |
| Top | |||
| Gallery | |||
| id | Integer PK | Unique key identifying a Gallery. | |
| title | Text | A one line title for the Gallery. | |
| note | Text | A full description of the Gallery. | |
| uid | Text | A universal identifier to identify this record across databases. | |
| changed | Integer | The date this record was last changed, held as a JDN. | |
| Top | |||
| GalleryMedia | |||
| id | Integer PK | Unique key identifying the Gallery media. | |
| title | Text | An alternative one line title for the Media when displayed in the Gallery. | |
| med_id | Integer FK | Pointer to the Media item to be displayed in the Gallery. | |
| gal_id | Integer FK | Pointer to the Gallery. | |
| med_seq | Integer | Sequence the Media is to be displayed in the Gallery. | |
| Top | |||
| Individual | |||
| id | Integer PK | Unique key identifying an Individual | |
| sex | Integer | This holds 0=Unstated, 1=Male, 2=Female and 3=Unknown. | |
| fam_id | Integer FK | Pointer to the default (preferred) Family ID | |
| note | Text | Any narrative necessary to distinguish this individual. | |
| privacy | Integer | A value indicating the privacy level for the Individual. | |
| name | Text | The full name or names that this Individual is known by. NOTE: Redundant field created from Persona/Names | |
| surname | Text | The surname name that this Individual is known by. NOTE: Redundant field created from Persona/Names | |
| epitaph | Text | The short date epitaph string ie (1914 - 1987). NOTE: Redundant field created from Events | |
| Top | |||
| IndividualEvent | |||
| id | Integer PK | Unique key identifying an IndividualEvent. | |
| higher_id | Integer FK | Unique identifier that indicates a higher IndividualEvent which contains this IndividualEvent. | |
| ind_id | Integer FK | Pointer to an Individual | |
| event_id | Integer FK | Pointer to the Event | |
| role_id | Integer FK | Points to the role played by the Individual | |
| note | Text | Optional note that relates to the Individual | |
| ind_seq | Integer | The sequence of Individuals included in a given event. | |
| Top | |||
| IndividualPersona | |||
| id | Integer PK | Unique key identifying a IndividualPersona record. | |
| ind_id | Integer FK | Pointer to an Individual | |
| per_id | Integer FK | Pointer to a Persona associated with a Reference | |
| conf | Float | A value, less than one, to indicate the confidence that the link is correct | |
| note | Text | Optional note that relates to this Individual - Persona link | |
| Top | |||
| Media | |||
| id | Integer PK | Unique key identifying a Media item. | |
| data_id | Integer FK | Pointer to the record holding the media data. May not be in current database. | |
| ass_id | Integer FK | Pointer to the associated database holding the data record. | |
| ref_id | Integer FK | Pointer to a Reference record. | |
| ref_seq | Integer | Number to indicate the order to be listed within a reference. | |
| privacy | Integer | A value indicating the privacy level for the Media. | |
| title | Text | The one line title text for the Media. Use Reference title if not given. | |
| note | Text | Additional text to support the Media. Is in addition to the Reference statement. | |
| uid | Text | A universal identifier to identify this record across databases. | |
| changed | Integer | The date this record was last changed, held as a JDN. | |
| Top | |||
| MediaData | |||
| id | Integer PK | Unique key identifying a MediaData item. | |
| title | Text | A title for the media that can be used without context. Also used as the default title. | |
| data | Blob | The binary data that makes up the media file. | |
| type | Integer | The format type of the media data. Acceptable types will be enumerated. | |
| privacy | Integer | A default value indicating the privacy level for the Media. | |
| copyright | Text | An optional text string holding copyright information. | |
| file | Text | Unique relative path and filename. | |
| uid | Text | A universal identifier to identify this record across databases. | |
| changed | Integer | The date this record was last changed, held as a JDN. | |
| Top | |||
| Name | |||
| id | Integer PK | Unique key identifying a Name. | |
| ind_id | Integer FK | Pointer to a Individual ID. | |
| per_id | Integer FK | Pointer to a Persona ID. Either the ind_id or per_id column should be 0. | |
| style_id | Integer FK | Pointer to a NameStyle ID to indicate the type of name, ie Married or Alias etc. | |
| sequence | Integer | Sequence of the Name within the Individual or Persona. The default name is the first in the list. | |
| Top | |||
| NamePart | |||
| id | Integer PK | Unique key identifying a NamePart. | |
| name_id | Integer FK | Pointer to the Name ID that this part belongs to. | |
| type_id | Integer FK | Identifier that indicates to which NamePartType this name belongs. | |
| val | Text | The value of the Name, such as "John" where type_id points to "Given name". | |
| sequence | Integer | A number to show a name's position in the full name | |
| Top | |||
| NamePartType | |||
| id | Integer PK | Unique key identifying a NamePartType. | |
| grp | Integer | Holds 0=Unstated, 1=Name part, 2=Title | |
| name | Text | Name of the NamePartType, ie "Given name" or "Rank" | |
| uid | Text | A universal identifier to identify this record across databases. | |
| changed | Integer | The date this record was last changed, held as a JDN. | |
| Top | |||
| NameStyle | |||
| id | Integer PK | Unique key identifying a NameStyle | |
| name | Text | Name of the NameStyle, ie "Birth name" or "Married name" | |
| uid | Text | A universal identifier to identify this record across databases. | |
| changed | Integer | The date this record was last changed, held as a JDN. | |
| Top | |||
| Persona | |||
| id | Integer PK | Unique key identifying a Persona. | |
| sex | Integer | This holds 0=Unstated, 1=Male, 2=Female and 3=Unknown. | |
| ref_id | Integer FK | If this persona was created by a reference entity, this identifies the Reference. | |
| note | Text | Any narrative necessary to distinguish this person. | |
| uid | Text | A universal identifier to identify this record across databases. | |
| changed | Integer | The date this record was last changed, held as a JDN. | |
| Top | |||
| Place | |||
| id | Integer PK | Unique key identifying a Place | |
| date1_id | Integer FK | A pointer to a Date when this Place was first recorded or the boundry set | |
| date2_id | Integer FK | A pointer to a Date when this Place is no longer recongnised or the boundry was changed | |
| uid | Text | A universal identifier to identify this record across databases. | |
| changed | Integer | The date this record was last changed, held as a JDN. | |
| Top | |||
| PlacePart | |||
| id | Integer PK | Unique key identifying a PlacePart | |
| type_id | Integer FK | A pointer to a PlacePartType that identifies the type of PlacePart this is. ie Town, Parish, County |
|
| place_id | Integer FK | A pointer to a Place that this forms a part of | |
| val | Text | The actual name of the place part | |
| sequence | Integer | A number to show the place parts position in the full place name (ie address) | |
| Top | |||
| PlacePartType | |||
| id | Integer PK | Unique key identifying a PlacePartType | |
| name | Text | The name of the PlacePart, such as Town, Country etc. | |
| uid | Text | A universal identifier to identify this record across databases. | |
| changed | Integer | The date this record was last changed, held as a JDN. | |
| Top | |||
| Reference | |||
| id | Integer PK | Unique key identifying a Reference record | |
| higher_id | Integer FK | Unique key identifying a higher Reference record, that this one forms a part. | |
| title | Text | Title of the reference document | |
| statement | Text | An document containing a statement which may include a Transcription, Translation, Summary of a Source or simple text statement. The document may be optionally marked up and provide links to the various elements. | |
| res_id | Integer FK | Key identifying the researcher who created this record. | |
| user_ref | Text | Optional user defined reference code. | |
| uid | Text | A universal identifier to identify this record across databases. | |
| changed | Integer | The date this record was last changed, held as a JDN. | |
| Top | |||
| ReferenceEntity | |||
| id | Integer PK | Unique key identifying a ReferenceEntity | |
| ref_id | Integer FK | Pointer to the Reference record | |
| entity_type | Integer | A value indicating the Entity type, 3=Place, 4=Date, 7=Name | |
| entity_id | Integer K | Pointer to the Entity record | |
| sequence | Integer | A number to give an entity's position in the list of a reference's entities | |
| Top | |||
| RelativeDate | |||
| id | Integer PK | Unique key identifying a RelativeDate. | |
| val | Integer | The relative value. | |
| range | Integer | The relative range | |
| unit | Integer | Sets the units for val and range: 0=Unstated, 1=Year, 2=Month, 3=Week and 4=Day. | |
| base_id | Integer FK | A pointer to the date the value is relative to. | |
| type | Integer | Indicates how the relative date is to be interpreted, 0=Unstated, 1=Age rounded down | |
| scheme | Integer | A number indicating the date scheme used for the date calculation | |
| Top | |||
| Repository | |||
| id | Integer PK | Unique key identifying a Repository | |
| name | Text | The full name of the Repository. May be an institution or an individual | |
| note | Text | Any pertinent notes about the Archive, such as the need to obtain a researcher's card, restrictions on the use of laptops, etc | |
| con_list_id | Integer FK | Unique key that identifies a ContactList for the Archive. | |
| uid | Text | A universal identifier to identify this record across databases. | |
| changed | Integer | The date this record was last changed, held as a JDN. | |
| Top | |||
| Researcher | |||
| id | Integer PK | Unique key identifying a Researcher. The default is the unknown Reseacher zero | |
| name | Text | The full name of the researcher. | |
| comments | Text | Optional comments about the researcher | |
| con_list_id | Integer FK | Unique key that identifies a ContactList for the Researcher. | |
| uid | Text | A universal identifier to identify this record across databases. | |
| changed | Integer | The date this record was last changed, held as a JDN. | |
| Top | |||
| System | |||
| id | Integer PK | Unique key identifying a System Setting | |
| val | Text | The value of the setting, may be text or a foreign key. | |
| Top | |||
| User | |||
| id | Integer PK | Unique key identifying a User | |
| res_id | Integer FK | A pointer to the Researcher corresponding to the User. Zero indicates the default User. | |
| Top | |||
| UserSetting | |||
| id | Integer PK | Unique key identifying a UserSetting. | |
| user_id | Integer FK | A pointer to the User for which the setting applies. | |
| property | Integer | A value indicating the property being set. | |
| val | Text | The value of the setting, may be text or a foreign key. | |
| Top | |||
| Version | |||
| id | Integer PK | Unique key identifying a Version record, 1=Full database version, 2=Media Data database version | |
| major | Integer | The Major version number. A change to this indicates a major change in the Database structure | |
| minor | Integer | The Minor version number. A change to this number indicates a possible non-reversible change | |
| revision | Integer | The Revision number. Changes to this number are reversible (ie it does not need to match the program) | |
| test | Integer | A Test number. Always zero in released code. Used during development for testing changes. | |
