DATA DICTIONNARY
----------------
gen_Addresses.acode ......... : Address zipcode
gen_Addresses.actry ......... : Address country
gen_Addresses.addr .......... : Address libel
gen_Addresses.aphon ......... : Phone at this address
gen_Addresses.aplac ......... : Address place (city)
gen_Addresses.idaddr ........ : ID of an address
gen_Addresses.myobs ......... : My personnal comments
gen_Marry.ecode ............. : Code of the city of this eventual end of union
gen_Marry.ectry ............. : Country of this eventual end of union
gen_Marry.edate ............. : Date of this eventual end of union
gen_Marry.eplac ............. : Place of this eventual end of union (city)
gen_Marry.idend ............. : ID of the eventual end of union
gen_Marry.idfam ............. : ID of the family
gen_Marry.idh ............... : ID of the husband
gen_Marry.idunion ........... : ID of the union
gen_Marry.idw ............... : ID of the wife
gen_Marry.myobs ............. : My personnal comments
gen_Marry.nchi .............. : Number of children (if known)
gen_Marry.ucode ............. : Code of the city of the union
gen_Marry.uctry ............. : Country of the union
gen_Marry.udate ............. : Date of the union
gen_Marry.uorder ............ : Order of this union (if several)
gen_Marry.uplac ............. : Place of the union (city)
gen_Marry.usour ............. : Source of the union (document, act)
gen_Notes.idnote ............ : ID of the note
gen_Notes.idpers ............ : ID of the person
gen_Notes.nallow ............ : Note allowed for display (0:no, 1:yes)
gen_Notes.norder ............ : Order of this note for this person
gen_Notes.note .............. : Note libel
gen_People.alias ............ : Alias of the person
gen_People.bcode ............ : Code of the place of birth
gen_People.bctry ............ : Country of birth
gen_People.bdate ............ : Date of birth
gen_People.bplac ............ : Place of birth
gen_People.bsour ............ : Source of birth (document, act)
gen_People.dcode ............ : Code of the place of death
gen_People.dctry ............ : Country of death
gen_People.ddate ............ : Date of death
gen_People.disp ............. : Display authorizations
gen_People.dplac ............ : Place of death
gen_People.dsour ............ : Source of death (document, act)
gen_People.fname ............ : First name
gen_People.icode ............ : Code of place of inhumation
gen_People.ictry ............ : Country of inhumation
gen_People.idaddr ........... : ID of his postal address
gen_People.idf .............. : ID of the Father
gen_People.idm .............. : ID of the Mother
gen_People.idpers ........... : ID of the person
gen_People.iplac ............ : Place of inhumation
gen_People.lname ............ : Last name
gen_People.mail ............. : Mail of the person
gen_People.mphon ............ : Phone (mobile) of the person
gen_People.pdate ............ : Year of the picture
gen_People.pic .............. : Picture filename
gen_People.porder ........... : Person order (in his family)
gen_People.sex .............. : Sex of the person
gen_Sources.file ............ : filename of the source (scanned document)
gen_Sources.idsrc ........... : ID of the source
gen_Sources.sallow .......... : Source allowed for display (0:no, 1:yes)
gen_Sources.source .......... : Reference of this document
gen_Unions.idunion .......... : ID of the type of union or end of union
gen_Unions.union ............ : Union or end of union libel
gen_Visitors.horodate ....... : Datetime of the visit
gen_Visitors.ip ............. : From this IP
gen_Visitors.page ........... : Viewed page
geo_Cities.city ............. : Name of the city
geo_Cities.code ............. : Zipcode of the city
geo_Cities.iddep ............ : ID of the department
geo_Cities.insee ............ : ID of the city (INSEE number)
geo_Cities.lat .............. : Latitude
geo_Cities.lon .............. : Longitude
geo_Cities.mcity ............ : Main city of the department (0:no, 1:yes)
geo_Countries.country ....... : Name of the country
geo_Countries.tld ........... : ID of the country (Top Level Domain)
geo_Departments.department .. : Name of the department
geo_Departments.iddep ....... : ID of the department
geo_Departments.idreg ....... : ID of the region
geo_Regions.idreg ........... : ID of the region
geo_Regions.region .......... : Name of the region
|
Download
