Cliquez ici pour la version francaise 
Oxy-Gen
Last update of the software :
May 29 2021 : Version 1.40o
The software
  Home
  Download
Documentation
  ChangeLog
  User manual
Users
  Forum
  Greetings
  Help
Links
  Search Engine
  Genealogical web sites
  Sites using Oxy-gen
 

MySQL DataBase Description

 

When you generate the database in the admin menu, the 8 tables described below are generated.

oxg_family
Column nameTypeComments
id_familyLONGINTPatronym ID
gedcom_nameTEXTName of the gedcom file
nameTEXTName of the family

oxg_patronyms
Column nameTypeComments
id_patronymLONGINTPatronym ID
libelleTEXTPatronym
libelle_ordTEXTPatronym without particle for the alphabetical order

oxg_individuals
Column nameTypeComments
id_familyLONGINTPatronym ID
id_individualLONGINTIndividual ID
id_fatherLONGINTFather ID (-1 if unknown)
id_motherLONGINTMother ID (-1 if unknown)
id_patronymLONGINTPatronym ID
first_nameTEXTName
sosaTEXTSosa number if sosa option is activated
contemporaryTEXTAbsent if reduced events option is activated

oxg_events
Column nameTypeComments
id_familyLONGINTPatronym ID
id_eventLONGINTEvent ID
id_type_eventLONGINTEvent type ID
type_fatherLONGINTType of the Father element (0=individuals table 1=events table)
id_fatherLONGINTID of the father element
libelleTEXTEvent text
contemporaryTEXTAbsent if reduced events option is activated
info_1TEXTcountry if place event/ind_id if asso event
info_2TEXTzone
info_3TEXTcity

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

Detailled events table (for a faster recovery of the main elements)

oxg_events2
id_familyINT NOT NULL
id_individuINT NOT NULL
id_eventINT NOT NULL
typeINT
libelleTEXT
devntDATE
sDtEvntTEXT
sPlaceTEXT
id_countryINT
id_zoneINT
id_cityINT

oxg_events_type
Column nameTypeComments
id_type_eventLONGINTID of the event type
codeTEXTGEDCOM code of the event
libelleTEXTText of the event

oxg_countries
Column nameTypeComments
id_countryLONGINTCountry ID
libelleTEXTCountry name

oxg_zones
Column nameTypeComments
id_zoneLONGINTZone ID
id_countryLONGINTCountry ID where is the zone
libelleTEXTZone name
codeTEXTZone code

oxg_cities
Column nameTypeComments
id_cityLONGINTCity ID
id_zoneLONGINTZone ID where is the city
libelleTEXTCity name
codeTEXTCity code

Copyright © 2000-2021