http://www.gystdoit.com/help/FAMILY_Data_Dictionary.htm
Monday March 28th, 2022 1:47:38 PM

Genealogical Accounting Framework (GAF) - Record of Families

FAMILY.DBF

Family Tree Data Base - FAMILY Level Production Data Table
Table Last Updated: 03/12/2022

Records: 275
Families
(There are some remarried)

Supporting File(s):
C:\JPG\FAMILY.CDX

Fieldname Type(Size) DescriptionExample
FAM_IDC(15)
  • Family ID is alpha numeric value that describes relationship to Root Family.
  • Family ID is assigned based on given family's position on the Root Family's family tree diagram. see FamilyTree_Number_Scheme.jpg
  • Can be visually mapped see FAMILY_TREE_desc.SVG
  • Provides base value to construct Individual ID
103
SURNAME C( 51) Family Surname (Last Name) Gaffey
FATHER_ID C( 12) IND_ID of the Father 1-3
FATHER C( 52) GIVEN Name of the Father John Gaffey
MOTHER_ID C( 12) IND_ID of the Mother 103-01
MOTHER C( 52) GIVEN Name of the Mother Ludmila Leytman
WED_DATE Date Date Father and Mother married 11/19/1988
CITY C( 30) This can serve as storage for gedcom Wedding Place information Rome, NY
PHOTO C(100)
  • File name of parent couple picture
  • Father-Mother together image file
  • could be Wedding Picture, Current Picture, or other

Naming Convention to tie photo to family

  • Use combination of Family ID and Surname to name the photo
  • for example
  • Gaffey_103_couple.jpg
  • Gaffey_103_wedding.jpg
  • Gaffey_103_19881118.jpg
    • (includes date stamp YYYYMMDD of when photo taken)

  • All Family Tree image files should have either a
  • Family ID (FAM ID) or
  • Individual ID (IND ID)
  • embedded in the filename
  • to provide reference control and support access

see Family_Member-PickLists.htm List of Existing Files


  • Gaffey_103_wedding.jpg