patronyms

Column name Type Comments

id_patronym LONGINT Patronym ID

libelle TEXT Patronym

libelle_ord TEXT Patronym without particle for the alphabetical order

individuals

Column name Type Comments

id_family LONGINT Patronym ID

id_individual LONGINT Individual ID

id_father LONGINT Father ID (-1 if unknown)

id_mother LONGINT Mother ID (-1 if unknown)

id_patronym LONGINT Patronym ID

first_name TEXT Name

sosa TEXT Sosa number if sosa option is activated

contemporary TEXT Absent if reduced events option is activated

events

Column name Type Comments

id_family LONGINT Patronym ID

id_event LONGINT Event ID

id_type_event LONGINT Event type ID

type_father LONGINT Type of the Father element (0=individuals table 1=events table)

id_father LONGINT ID of the father element

libelle TEXT Event text

contemporary TEXT Absent if reduced events option is activated

info_1 TEXT country if place event/ind_id if asso event

info_2 TEXT zone

info_3 TEXT city

if reduced events option is activated, you will find only place and date of birth, marriage and death events

events_type

Column name Type Comments

id_type_event LONGINT ID of the event type

code TEXT GEDCOM code of the event

libelle TEXT Text of the event

countries

Column name Type Comments

id_country LONGINT Country ID

libelle TEXT Country name

zones

Column name Type Comments

id_zone LONGINT Zone ID

id_country LONGINT Country ID where is the zone

libelle TEXT Zone name

code TEXT Zone code

cities

Column name Type Comments

id_city LONGINT City ID

id_zone LONGINT Zone ID where is the city

libelle TEXT City name

code TEXT City code